Microsoft KB Archive/249177
Article ID: 249177
Article Last Modified on 8/18/2005
- Microsoft Excel 95 Standard Edition
- Microsoft Query 2000
This article was previously published under Q249177
When you enter a date in the Criteria pane of your query, you receive an error message similar to one of the following:
where <Table Name> is the name of the table and <Fieldname> is the name of the field that you are querying.
NOTE: This error message will vary according to the version of Microsoft Data Access Components installed. It also will vary depending on the driver.
This issue will occur 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 issue, 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.
Additional query words: XL2000 y2k Query95
Keywords: kbprb KB249177