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!
@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.
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!
@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.