I am importing data into Excel via an ODBC database. I want to pull data based on a date field in the record if it is less than the current date (Todays Date). The format of the date field in the database is ccyy-mm-dd (eg. 2009-01-22). If I put in a valid date (#01/21/2009#) in the Criteria field of Microsoft Query it works fine. When I put TODAY() or NOW() or =TODAY() or =NOW() it fails with "Syntax Error in Date". If I rearrange the database date with the MID and RIGHT functions inot mm/dd/yy and try the compare in the SQL ciew it still errors.
Any help is much appreciated.
Bookmarks