Scheduled report is showing GMT time not local time when output is taken in excel
Hi, Scheduled report is showing GMT time not local time when output is taken in excel. Is there any way to fix this issue.
Posted: 3 years ago
Posted: 3 years ago
Hi Amit,
Pega always maintains DateTime properties in GMT timezone internally.
To convert to any other timezone, FormatDateTime function is provided.
example:
@(Pega-RULES:DateTime).FormatDateTime(@DateTime.CurrentDateTime(),"yyyy-MM-dd'T'hh:MM:ss", "EST", "en_US")
Please note that the output of @FormatDateTime is a String (a Text property) not a DateTime property.
Check below pdn article:
https://pdn.pega.com/support-articles/format-date-time-est-not-gmt
Thanks,
Susan
Hello Amit,
Thanks for posting your query in PSC :)
Can set to a date property like below and use the same in report?
@FormatDateTime(@CurrentDateTime(), "yyyyMMdd'T'HHmmss.SSS", "EST5EDT", "en-US") + " GMT"
If it does not work, share the screenshot of the report displaying to datetime property. This is to see if you are using the property directly or referring a function.
Regards,
Rincy