Many data files (especially from older systems) use two digits to represent the year. The year used to denote the earliest date in the last century can vary from one set of data files to the next. The two-digit year that indicates the oldest record in the last century is often called the start of century date or the pivot date.
The start of century date applies to two-digit year date fields only and will not affect dates that use three or four digits to represent the year. Analyzer can read four-digit year dates to 9999.
The default setting is 40. To change the start of century date, enter a two-digit number from 1 to 99. Analyzer will not accept a zero value. For example, if you choose to set 1940 as the separating year, enter 40 in the Start of Century text box. Analyzer then treats years 40 to 99 as 1940 to 1999 and years 00 to 39 as 2000 to 2039.
The following table illustrates possible Start of Century dates.
Start of Century Date |
Years |
Display as dates |
60 |
60 to 99 00 to 59 |
1960 to 1999 2000 to 2059 |
40 |
40 to 99 00 to 39 |
1940 to 1999 2000 to 2039 |
05 |
05 to 99 00 to 04 |
1905 to 1999 2000 to 2004 |
When working with data files that use a different pivot date, you can use an expression to create a computed field that correctly interprets the two-digit year or converts it to a four-digit year.
SET CENTURY 0-99