Check date falls between dates(Validate date)

[#1]

Hi,

I have to check if the archive date falls between the start and end date of the reference table for a particular ID. Please find attached qvw. I need to display the ID which doesn't exists in ref and doesn't have valid date. For the below, I should have jkl,asf and def id's displayed.

Please advice.

Thanks,

[Gysbert_Wassenaar · Accepted solution]

You can use the IntervalMatch function for this. See this blog post for more information: IntervalMatch

[#3]

Thank you Gysbert...