How Microsoft Query handles year 2000 dates

Four-digit years are recommended To ensure that year values are retrieved and interpreted correctly, make sure your external databases store year values as four digits (2001 instead of 01) whenever possible.

Query and Microsoft Excel interpret two-digit years consistently Query and Excel both interpret two-digit years in the same manner. When you view data that contains two-digit year values in Query and then return the data to Excel, the year values are the same in both programs.

How Query interprets two-digit years When Query retrieves a two-digit year value from an external database, Query interprets the year as follows:

• Year values 00 through 29 Two-digit year values 00 through 29 are interpreted as the years 2000 through 2029. For example, if Query retrieves the date 5/28/19 from an external database, Query interprets the date as May 28, 2019.
• Year values 30 through 99 Two-digit year values 30 through 99 are interpreted as the years 1930 through 1999. For example, if Query retrieves the date 5/28/98 from an external database, Query interprets the date as May 28, 1998.

Administrators can change how years are interpreted Your system administrator can customize Microsoft Office so that different rules determine how dates are interpreted. For example, your administrator can change the earliest two-digit year value that's interpreted as a future date from 29 to another number. To find out if your system uses customized date interpretation, see your system administrator.