Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/249172

From BetaArchive Wiki
Knowledge Base


Query98: Error Message: "Invalid Date Escape..." Performing Query with a Date

Article ID: 249172

Article Last Modified on 9/11/2002



APPLIES TO

  • Microsoft Excel 98 for Macintosh
  • Microsoft Query 2000



This article was previously published under Q249172


SYMPTOMS

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

Invalid date escape. Correct syntax is {d 'yyyy-mm-dd'}.


NOTE: This error may vary, depending on the driver you are using.

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 issue, 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.


Additional query words: XL2000 y2k

Keywords: kbprb kbpending KB249172