Support Article
Generated Report, has incorrect Date time in ‘Export to excel’
SA-67803
Summary
A generated report has an incorrect DateTime in the Export to Excel or PDF file name.
Error Messages
Not Applicable
Steps to Reproduce
- Log in to the portal.
- Invoke a report from the ReportBrowser section.
- Export the report to both Excel and PDF.
- Check the 'Generated on'. The 'Generated on' reflects the server time in both Excel and PDF report file title, as well as in the PDF report body.
ROOT CAUSE
This behavior is as per Pega product design.
Resolution
Here’s the explanation for the reported behavior:
The Date format displayed on screen is different from the Date which is saved in the Clipboard.
Pega stores dates in GMT format internally. Hence, when exporting to Excel, the GMT Date format is passed to Excel.
Published December 11, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.