all our date time stamps are of this format:
01/01/2004
dd/mm/yyyy
not sure if your date settings are different, but you might want to try it
that way and see if that works.
----- Original Message -----
From: "Fogelson, Steve" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 17, 2004 10:01 AM
Subject: [RBASE-L] - [No Subject]
> Windows 3002 Web Edition, R:Tango 5, Oterro update 3
>
> Can't figure out what is wrong with the following DBMS action:
>
> SELECT B2.B_ID, B2.B_ShopperID, P1.P_Name, B2.B_Quantity, P1.P_Price1,
> B2.B_TimeStamp FROM Products P1, Basket B2 WHERE ((P1.P_ID=B2.P_ID) AND (
> (b2.B_TimeStamp >= '2004/01/01 00:00:01') and ('2004/12/01 23:23:59' <=
> b2.B_TimeStamp) ))
>
> 2418 [RBTI][Oterro ODBC Driver][Catalog]-ERROR- Invalid DATETIME value
> (2418) S1000
>
> I have tried 2004/12/01, 12/01/2004, 12/01/2004 23:23:59. Nothing seems to
> work.
>
> b2.B_TimeStamp is a field with the Timestamp Datatype.
>
> Any ideas?
>
> Steve Fogelson
> Internet Commerce Solutions
>
