Query97: "Syntax Error (Missing Operator)..." Error Performing Query with a Date

ID: Q249168

The information in this article applies to:
  • Microsoft Query 97 for Windows

SYMPTOMS

When you enter a date in the Criteria pane of your query, you receive an error message similar to the following

Syntax error (missing operator) in query expression '(Table Name.Fieldname=d '100-07-04'})'.
where Table Name is the name of the table and Fieldname is the name of the field that you are querying.


CAUSE

This issue occurs when the following conditions are true:

  • You enter a date value that does not include the year.

    -and-

  • The current date setting on your computer is later than December 31, 1999.


WORKAROUND

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.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


REFERENCES

For additional information about using dates with MSQuery, click the article number below to view the article in the Microsoft Knowledge Base:

Q187698 Query97: MSQuery Uses 1900 Date When Two Digits Are Used for Year

Additional query words: XL2000 y2k XL97

Keywords : kbdta kb2000 xlquery
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: January 18, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.