Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Incorrect dates for 100 years in export to excel from reports



User has a date field with control as Date or pxDateTime.

The value of this property is 01/01/1917.

When user runs the report with this date field column, it displays the date as 01/01/17 for pxDatetime control and 01/01/1917 for Date control fields.

However, on export to excel the date fields show up with current year (01/01/2017) for both controls.

Error Messages

Not Applicable

Steps to Reproduce

1) Create Date field with control as Date or pxDateTime.
2) Create a report definition include the created date field and give the input for date field as dd/mm/1917.
3) Run the report and click Export to excel.

Root Cause

Need to change the date format in pzExport_Date_RD control from DEFAULT_DATE_SHORT to DEFAULT_DATE_SHORT_YYYY.


Apply HFix-32970.
Suggest Edit

Published April 10, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us