ACC2: All Two-Digit Dates Imported from Text Resolved in 1900s (230593)

The information in this article applies to:

Microsoft Access 2.0

This article was previously published under Q230593

Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

When you import data from a text file into Microsoft Access, dates that contain years with two digits are always interpreted as years between 1900 and 1999.

CAUSE

Microsoft Access 2.0 does not interpret two-digit years between 00 and 30 as years between 2000 and 2030.

RESOLUTION

When you import data from a text file, ensure that all the date values use a format with a four-digit year. For example:

1/1/1999

-or-

Jan 1, 1999

You can also resolve this problem by downloading the update discussed in the "Status" section of this article.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Access 2.0. This problem is resolved by the Microsoft Access 2.0 Date Update.

To obtain the update, please see the following article in the Microsoft Knowledge Base:

231408 ACC2: Access 2.0 Two-Digit Date Update Available in Download Center

MORE INFORMATION

Microsoft Access 2.0 assumes that all imported two-digit dates are between 1900 and 1999. For more detailed information on two-digit dates and Access 2.0, see the following article in the Microsoft Knowledge Base:

75455 ACC2: Years Between 00 and 29 Are Interpreted as 1900 to 1929

Modification Type:	Major	Last Reviewed:	10/22/2002
Keywords:	kbbug KB230593