Microsoft KB Archive/249168

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

Article ID: 249168

Article Last Modified on 8/30/2002

-

APPLIES TO


 * Microsoft Query 2000

-



This article was previously published under Q249168





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 '( . =d '100-07-04'})'.

where  is the name of the table and   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 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.

