Dates

The system determines how a date is converted from the flat file to the EDI interface tables through a combination of the date-format user preference that you set up in the default value that you specify for the UDS for the century change year (CENTCHG in 00/DF).

The date format specified in the date-format user preference setup must match the date format of all dates in the flat files. Typically, this format is MDY and is the format used by ANSI EDI data; however, it might vary with other standards. The conversion of the dates from the flat files to the inbound interface tables is based on a combination of the user preference and the data dictionary item CENTCHG. When you enter a date with two positions for year, the system compares that value with the default value within CENTCHG to determine whether the date is less than or equal to this value. For example, if the date is less than or equal to this value and it is a value within the year 2000 (00,01,02 up to and including the default value), the system interprets the date as a year 2000 date.

If the date is greater than the default value, the system assumes the current century as defined in data dictionary item CTRY. For instance, if the CENTCHG default value is 10 and the date-format user preference that you set up is MDY, the system formats the date as described in this table after you run the Inbound Flat File Conversion program (R47002C):

Desired Date	Format in Flat File	Formatted Date in Interface Table	Typical Date Storage in Interface Table (Julian)
June 1, 1998	6/1/98	6/1/98	98152
June 1, 2002	6/1/02	6/1/02	102152
June 1, 2010	6/1/10	6/1/10	110152
June 1, 2011	6/1/11	6/1/11 *Incorrect	11152 *Incorrect
June 1, 2015	6/1/15	6/1/15 *Incorrect	15152 *Incorrect
June 1, 1998	6/1/1998	6/1/98	98152
June 1, 2010	6/1/2010	6/1/10	110152
June 1, 2011	6/1/2011	6/1/2011	111152
June 1, 2015	6/1/2015	6/1/2015	115152

* Indicates a date that was converted incorrectly based on the desired date in the preceding examples.