Question

2
Replies
601
Views
AnirDas1 Member since 2016 6 posts
Tata Consultancy Services
Posted: 2 years ago
Last activity: 2 years 3 months ago
Closed

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

Reporting
Moderation Team has archived post
Share this page LinkedIn