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:
EMP_FULL_NAME as "Employee",
From [$(vLocalDevPath)\TABLE1.qvd] (qvd);
APPL_NAME as Application,
From [$(vLocalDevPath)\TABLE2.qvd] (qvd);
IntervalMatch (AccessDate) LOAD Distinct MeetingDate, PublishedDate Resident DATE_ACCESS;
INNER JOIN (DATE_ACCESS)
MeetingDate & '-' & PublishedDate AS DateKey,
DROP TABLE DateMatchTemp;
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?
If I understood Well, then you need to Filter The Records on the basis of "Access Date". Which you are saying is depending on two different Dates, 1. Meeting Date, and 2. Published Date. Am I Right?
If you already have two separate calender then problem is solved, that take vStart Varibale date from Meeting date Calnder and vEnd Variable date from Published Date.
This way you are not selecting anything in data model, that means all data is present not filtered.
Now you can make your expression like:
Count(If(AccessDate>=vStart and AccessDate<=vEnd, ID))
I guess this should work, if not then reply back.