Query98: MSQuery Uses 1900 Date When Two Digits Are Used for the Year (187699)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
- Microsoft Query
This article was previously published under Q187699 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.
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:
179216 How to Use the Microsoft Office Installer Program
Modification Type: | Major | Last Reviewed: | 9/11/2002 |
---|
Keywords: | kbprb KB187699 |
---|
|