Query2000: "Syntax Error (Missing Operator)..." Error Performing Query with a Date (248222)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Query
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 '(Table Name.Fieldname=ts '100-11-16 00:00:00'})'.
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.
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.
STATUSMicrosoft 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.
| Modification Type: | Major | Last Reviewed: | 10/31/2003 |
|---|
| Keywords: | kbpending kbprb KB248222 |
|---|
|