You are here: Field Types > DateTime > Two-digit Years in Dates

Two-digit Years in Dates

Many data files use two digits to represent the year. The year used to denote the earliest date in the last century varies from one set of data files to the next. The two-digit year that indicates the oldest year in the last century is often called the start of century date or the pivot date.

The way that Analyzer reads two-digit years depends on your Start of Century preference setting. With the default setting of 40, Analyzer interprets the years 40 to 99 as 1940 to 1999 and the years 00 to 39 as 2000 to 2039. Analyzer uses this setting whenever it encounters data that uses two digits to represent the year in a table. It will not affect data that uses three or four digits to represent the year.

To change the default setting, see Start of Century Date. See also Set with Preference Equivalents.