David Herrera (DavidH0692)
Rules Cube
Rules Cube
DavidH0692 Member since 2013 2 posts
Rules Cube
Posted: January 28, 2019
Last activity: December 2, 2020
Posted: 28 Jan 2019 11:16 EST
Last activity: 2 Dec 2020 2:02 EST

How to calculate DateTime values in report using operator's timezone?

I have a report where I must select cases that were resolved in a specific timeframe

I'm using functions like Day of the week of and Difference in days between to compare dates in the required logic, but I see it doesn't take the operator's timezone (MST), this results in incorrect report results where some cases that fall in one day in MST but are actually in the next one in GMT are not being selected.

This report is being used in the My Reports tab and thus, can't implement a response data transform in a data page, and there doesn't seem to be a way to transform the dates using activities or java functions either.

Pega Customer Service Low-Code App Development Reporting