Understanding Your Data Model › Using Fields › ISO Date › Internal Format

Internal Format

DTE dates are stored on file by systems generated by CA 2E as follows.

• DTE dates greater than or equal to 1900 are stored on file in CYYMMDD format.
• DTE dates earlier than 1900 are stored on file as a negative value.

The following table shows the internal format for April 5 for various years.

The valid date range is January 1, 1801 to December 31, 2199. When no date is entered, the internal representation is zero (0).

The internal format ensures that

• An historical view can be obtained. In this format dates can be ordered into ascending or descending order using the database.
• The stored internal format is independent of the displayed external format, namely, independent of the date format used in a particular country.