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

ID: Q230593

The information in this article applies to:
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 patch 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 Patch.

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

Q231408 ACC2: Access 2.0 Two-Digit Date Patch Available on MSL


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/y2k/

Additional query words: pra Y2K year date text import kb2000 


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

Last Reviewed: May 10, 1999