Getting the match result eventhough the value is not exiting in the range

Hi, I am facing a silly issue.
I am checking the date between the two tables. In dt1 I have a date and dt2 I have two column-like starts & end date.
So I am checking the date from dt1 like is it fall between the start and end date in dt2. So I am getting all the results Match. Can you check whether the condition is wrong?
image

@Palaniyappan @Lahiru.Fernando

2 Likes

there is small correction in the second part of the CONDITION
like it should be
…AND dt.Select(β€œ[Date End] < '”+absdate+"’ ").count>0

Cheers @balkishan

1 Like

Hi @balkishan

try this

Dt.Select(β€œ[Date Start]<'”+absdate+β€˜β€œβ€).count>0 and absdate"’>[Date End]").Count>0

Thanks
Ashwin S

1 Like