Checking if Date field 1 is between Date field 2 and Date field 3
I have 3 date fields in 3 separate tables - the 3 tables are joined together. I need to provide a date input in my report that allows the user to filter the results where Date field 1 (called AccessDate) is between a range of Date field 2 (called MeetingDate) and Date field 3 (called PublishedDate). So, the desired logic is, return results where AccessDate is between the chosen MeetingDate and the chosen PublishedDate.
I would like to be able to use one calendar object for the AccessDate and another calendar object for the PublishedDate, but the resultant date range is applied against the AccessDate.
Is this possible in QlikView? If it's not, are there any suggestions for implementing this some other way?
The MeetingDate and PublishedDate fields come from one table and the AccessDate field comes from another table - these two tables are then joined together into one table named DATE_ACCESS - please see below and please see the IntervalMatch code:
The report will have two calendar objects - one for MeetingDate and one for PublishedDate; my question is, how do I implement the IntervalMatch code in the GUI, using the two calendar objects, so that the logic returns the data where the AccessDate is between the chosen MeetingDate and PublishedDate values? What changes have to be made to the relevant sheet objects?