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

Pega Default Date Value is stored as 01011970 in database



When setting the Date property as blank, the Date value is stored as '01011970' in the database.

Error Messages

Not Applicable

Steps to Reproduce

  1. Add a repeat grid sourced with an editable datapage containing a Date property as a column whose value changes dynamically using a declare expression depending on a boolean property.
  2. Perform a filter on the date property.

Root Cause

An issue in the custom application code or rules.


Perform the following local-change:

Alter the declare expression to set the Date to avoid the below condition in a single statement as displayed in the below image.

For example, condition: .NRFI = true ? @getCurrentDateStamp(): ""

Instead, use the 'Whenever used (if - otherwise)' step in the declare expression and set the value as blank as displayed below to avoid '01011970' in the database.

Additionally, create and use the following Dynamic System Setting (DSS) related to the default date.
Pega-IntegrationEngine. disableEpochDateTime When a DateTime property is set to an empty value, it returns the epoch DateTime (01-jan-1970) by default. Set this value to "true" to have the property return no value.

Suggest Edit

Published September 19, 2018 - 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