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.