How to list items in Report Definition with deadline after two days after
Hi,
We have a scenario where we need to create a report definition scheduled daily. The report will collect all items with Deadline Time = Current Day+2. To implement this we have tried using function pxDifferenceInHours() as well as pxDifferenceInDays(). However looks like since these functions doesn't consider business calendar, the report will not work properly for Friday.
The below we tried in filter:
The difference in hours between ( The current system date and time as a DateTime value ) and A.pxDeadlineTime >= 48
AND
The difference in hours between ( The current system date and time as a DateTime value ) and A.pxDeadlineTime <= 72
Please help me with solution to the above issue.
Thanks in Advance