topic Re: Check date falls between dates(Validate date) in QlikView

Check date falls between dates(Validate date)

Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Check date falls between dates(Validate date)

Gysbert_Wassenaar — Fri, 19 Aug 2016 14:08:16 GMT

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

Re: Check date falls between dates(Validate date)

Fri, 19 Aug 2016 14:14:14 GMT

Thank you Gysbert...