Article ID: 75455 - View products that this article applies to.
This article was previously published under Q75455
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.
When you enter dates by using two-digit years in Microsoft Access version 2.0, the year is always placed between 1900 and 1999.
Microsoft Access 2.0 assumes that all two-digit years are between 1900 and 1999.
When you enter dates in Access 2.0, enter the dates by using four-digit years.
You can resolve this problem in two different ways:
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:
(http://support.microsoft.com/kb/231408/EN-US/ )ACC2: Access 2.0 Two-Digit Date Update Available in Download Center
When you install the Access 2.0 Date Update described in the "Status" section, the following functionality will be updated or added to Access 2.0:
Access 2.0 Now Supports a Sliding Date WindowThe 100 year sliding date window provides a range of years that defines where any given two-digit year falls. For example, if you have defined a 100 year sliding date window from 1930 to 2029, two-digit years between 00 and 29 will fall in the 2000s whereas two-digit years between 30 and 99 will fall in the 1900s. You add the setting for the sliding window for Access 2.0 in the Win.ini file. To add the setting to the Win.ini file, open the file in any text editor, such as Notepad, and add the following section:
[Microsoft Access 2.0]In the new section, add the following setting:
TwoDigitYearMax = The maximum year in your windowFor example, if you want to have a sliding date window from 1930 to 2029, add the following to the Win.ini file:
[Microsoft Access 2.0]If you do not set the value for the sliding date window, Access 2.0 will assume that two-digit years fall within the 1900s.
TwoDigitYearMax = 2029
Two-Digit Years in Property Sheets and the Query Design Grid Will Be Displayed as Four-digit YearsWhen you enter date values or expressions that contain date values into property sheets or the query design grid, dates that contain two-digit years will be displayed according to the 100 year sliding date window. If you have not set the sliding date window as described in the "Access 2.0 Now Supports a Sliding Date Window" section, the dates will be displayed as falling between 1900 to 1999.
The following is a list of properties that you might enter dates into:
Two-digit Years in Access Modules Will Be Displayed as Four-Digit YearsWhen you enter a literal date into a module, the date is stored as a double-precision, decimal value that represents a specific date. After the update is applied to a computer, literal dates containing two-digit years will be stored and displayed according to the sliding date window defined in the Win.ini file. Examples of literal dates in modules include:
Dates Entered Without a Year Will Fall Within Current YearThis update fixes a problem in Access 2.0 that causes dates without years to return the incorrect system year if the system clock is set to the year 2000 or later.
Dates with Two-Digit Years Imported from Text Files Will Be Interpreted as Falling Between 1930 and 2029When you import a text file that contains dates that have a two-digit year, the date is always considered as falling between 1930 and 2029. Dates imported from text files do not use the sliding date window defined by the Win.ini file. For additional information about importing text files with dates into Access 2.0, please click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/230593/EN-US/ )ACC2: All Two-Digit Dates Imported from Text Resolved in 1900s
Important Information about Existing Dates in Your DatabaseWhen you install the Access 2.0 Date Update, the dates stored in your existing databases are not automatically converted from two-digit to four-digit dates. You must consider three important facts when using existing databases that contain dates in property sheets, the query design grid, or Access modules.
For additional information about how Access stores Date/Time values, please see the "More Information" section of following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/130514/EN-US/ )ACC: Storing, Calculating, and Comparing Date/Time Data
Article ID: 75455 - Last Review: October 7, 2013 - Revision: 1.1