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?
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