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

ID: Q230593

The information in this article applies to:

Microsoft Access 2.0

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 this to be 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:

Q231408 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:

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

REFERENCES

For more information about how Microsoft products are affected by year 2000 (Y2K) issues, please see the following Microsoft World Wide Web site:

http://www.microsoft.com/year2000/

Additional query words: pra Y2K year date text import kb2000

Keywords : kbdta
Version : WINDOWS:2.0
Platform : WINDOWS
Issue type : kbbug