Support Article
Default date value is exported to Excel
SA-91551
Summary
The default date value (1/1/1970) is exported to Excel if the date column value is null in the database.
Error Messages
Not Applicable
Steps to Reproduce
- Invoke the pxGenerateExcelFile activity with a parameter as the Binary Excel file
- Run the activity
- Verify the Excel data
Root Cause
Apache POI displays the default date (1/1/1970) if the date property value is empty.
Resolution
This issue was reported as a bug to be remediated in Pega 8.3 patch release.
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.