Since you asked for ideas and not solutions, how about using BETWEEN value1 AND value2? Also, you need to match the date and time format to the actual data or change the format before your select statement SET DATE FOR, SET TIME FOR...
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fogelson, Steve Sent: Wednesday, March 17, 2004 12:01 PM To: RBASE-L Mailing List 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 --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
