Microsoft KB Archive/248222

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

Article ID: 248222

Article Last Modified on 10/31/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q248222





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 '( . =ts '100-11-16 00:00:00'})'.

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.



RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

To temporarily work around this 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.

Additional query words: XL2000 y2k

Keywords: kbprb kbpending KB248222

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.