Query98: MSQuery Uses 1900 Date When Two Digits Are Used for the Year

ID: Q187699

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition
Microsoft Query 98 Macintosh Edition

SYMPTOMS

When you perform a query in Microsoft Query 98 Macintosh Edition, and you use two digits for a year in the criteria, Microsoft Query may return records that meet criteria other than the criteria you specify.

CAUSE

When you use two digits for a year in the criteria pane, Microsoft Query always assumes by design that the year is between 1900 and 1999. This behavior occurs for dates that you enter in the value field of the Criteria pane and for dates that you use in parameter queries.

WORKAROUND

To retrieve dates outside the years 1900-1999, use four digits for the year in the query.

STATUS

This behavior is by design of Microsoft Query 98 Macintosh Edition.

MORE INFORMATION

If two records have the following two values in a date field

1/1/1919
1/1/2019

and you use #1/1/19# in the criteria pane of Microsoft Query, only the record containing the value 1/1/1919 is returned. If you change the criteria to #1/1/2019#, the record containing the value 1/1/2019 is returned.

This behavior is different from the behavior in Microsoft Excel 98 Macintosh Edition. In Excel 98, if you use two digits for any years between 0 and 29 (inclusive), the date is assumed to be 2000 to 2029. If you use two digits for years between 30 and 99 (inclusive), the date is assumed to be 1930 to 1999.

If you insert or update records using the Data pane in Microsoft Query, you should also use four-digit years for dates you enter. Otherwise, Query will assume any two-digit years are between 1900 and 1999.

REFERENCES

For more information about adding criteria, click the Office Assistant, type adding criteria click Search, and then click to view "Specify what records to retrieve by using criteria."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

Q179216 How to Use the Microsoft Office Installer Program

Additional query words: XL98 OFF98 y2k year2000 2000

Keywords : kbdta kb2000 xlquery xlmac
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb