Microsoft KB Archive/249168
Article ID: 249168
Article Last Modified on 8/30/2002
- Microsoft Query 2000
This article was previously published under Q249168
When you enter a date in the Criteria pane of your query, you receive an error message similar to the following
Table Name is the name of the table and
Fieldname is the name of the field that you are querying.
This issue occurs when the following conditions are true:
- You enter a date value that does not include the year.
- The current date setting on your computer is later than December 31, 1999.
To work around the problem, always specify the year portion of the date when your system clock is set to a date later than December 31, 1999.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.
For additional information about using dates with MSQuery, click the article number below to view the article in the Microsoft Knowledge Base:
187698 Query97: MSQuery Uses 1900 Date When Two Digits Are Used for Year
Additional query words: XL2000 y2k XL97
Keywords: kbprb kbpending KB249168