Need to have Report Definition date in Central Time Format
Hello Everyone,
We have a use case where we are sending 'yesterday' records to a CSV and storing it in the repository. The CSV File should have CST time records (12-12 CST). By default pega is sending records in GMT format and GMT 12-12.
How can we convert GMT time values to CST in the report Definition.
Any suggestions?
Thanks in Advance!
***Edited by Moderator Marije to add Capability tags***
Accepted Solution
Updated: 2 Jun 2023 8:05 EDT
Pegasystems Inc.
GB
@Priyesh I was only able to find this documentation about Evaluation of symbolic dates and a previous forum question Is it possible to add a new Symbolic Date range?
FDBK-15131 (if relevant) is still unassigned.
Updated: 23 Jan 2023 7:43 EST
Pegasystems Inc.
GB
@Priyesh questions like these have been asked many times on the forum - did you already try some suggestions such as this one, this one and this one? You'll need to format the datetime field before export.
Our documentation can be found here:
Understanding the Date, TimeofDay, and DateTime property types
See explanations given in Issue with Date time property displayed as date on UI
Our Troubleshooting Date Time Issues support document contains many suggestions.
Ernst & Young LLP
IN
Hi Marije, Thanks for your response.
Yes, have gone through these suggestions.
But in our use-case, we are using report Definition. as the source, called from data flow.
And in report Definition, we cant use any function, we can only use function alias.
I also tried creating one function alias with timezone casting but that didn't work.
Report is generated with below steps:
Job Scheduler Run at 1 AM EST >> Calling Activity >> Data Flow >> Source: Report Defination (with Param as .pxOutcometime='Yesterday') and Destination: File Data-Set (Generates CSV report and stores to repository folder)
Any more suggestions would be useful.
Thanks!
Accepted Solution
Updated: 2 Jun 2023 8:05 EDT
Pegasystems Inc.
GB
@Priyesh I was only able to find this documentation about Evaluation of symbolic dates and a previous forum question Is it possible to add a new Symbolic Date range?
FDBK-15131 (if relevant) is still unassigned.