You mean I have to explain this AGAIN... :-> Just kidding, Tore.
PS: The CAST() function does not allow specifying the format used explicitly, so my post will mention CONVERT() and not CAST()... -----Original Message----- From: David L. Penton [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 4:20 PM To: ActiveServerPages Subject: RE: Date filtering on SQL Can you honestly say that a "date" is in that sql statement? I see a mathematical expression: 08 / 23 / 2002 which is roughly equal to 1.737 x 10^-4 Dates are delimited by ' in sql server. Use ISO format. Consider [Tore's explanation when he posts it because he loves this topic :-) and] CAST('20020823' as DATETIME) David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: M. H. K. [mailto:[EMAIL PROTECTED]] Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: Incorrect syntax near '>'. sSQL="Select * from Subscribe Date > 08/23/2002" I'd appreciate it if someone could point out what the problem is here ? --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
