Using =Date()

[Bad Bear]

I am trying to use =Date() or DateSerial in a query to extract data using ODBC and I receive a message stating "Reserved Error (-7713); there is no message for this error". When I use an actual date, such as 10/18/02, the query works correctly.

I would appreciate any suggestions, as this is quite frustrating. I am using Windows 2000 Professional(SP-3) with Access 2000(Office 2000 SR-1).

Thanks in advance,

Mike

 

[EndersG]

Instead of =Date(), try Date() in the criteria (and be sure the data type is set to Date/Time

 

[Stew]

Hey Mike,

If you could post the SQL string/code you are using, it might help give us a better idea of what is going on. Maybe it's just something in the syntax.

Paul

 

[Bad Bear]

Stew:
Here is a copy of the SQL:

SELECT [Tab-Sales Order Detail File].Identifier2ndItem, [Tab-Sales Order Detail File].ActualDeliveryDate, [Tab-Sales Order Detail File].UnitsTransactionQty, DateSerial(Year(Date()),Month(Date())-1,1) AS Expr1
FROM [Tab-Sales Order Detail File]
WHERE ((([Tab-Sales Order Detail File].ActualDeliveryDate)<=Date()));

If you notice something odd, please let me know.

Thanks again,

Mike