Brian: you might have grief with the delims: SQLServer date delims: ' Jet/MSAccess date delims: #
which means > Where receivedDate > ###10/1/2004### YUCK! that's why I religiously used cfqueryparams (with no grief) you might also have issues with dd/mm/yyyy vs mm/dd/yyyy since the internal JET db engine bypasses the MSAccess settings try these formats instead. the second is more correct but the first seems to work (from memory) > Where receivedDate > #2004/1/10# or > Where receivedDate > #2004-1-10# cheers barry.b -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of KNOTT, Brian Sent: Thursday, 7 October 2004 11:09 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Access Date formats I'm not having much luck with it. -----Original Message----- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Thursday, 7 October 2004 11:01 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Access Date formats I take it you can't use <cfqueryparam> ? Mark On Thu, 7 Oct 2004 10:44:58 +1000, KNOTT, Brian <[EMAIL PROTECTED]> wrote: > > > > Does anyone know the correct format for a select statement to query an > Access database based on a date > > > > i.e. > > > > Select * > > From table > > Where receivedDate > '10/1/2004' > > > > Brian > > > ------------------------------------------------------------------------ ---- ------- > This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of > its related entities ("Suncorp"). > > Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 > 11 55 or at suncorp.com.au. > > The content of this e-mail is the view of the sender or stated author and > does not necessarily reflect the view of Suncorp. The content, including > attachments, is a confidential communication between Suncorp and the > intended recipient. If you are not the intended recipient, any use, > interference with, disclosure or copying of this e-mail, including > attachments, is unauthorised and expressly prohibited. If you have received > this e-mail in error please contact the sender immediately and delete the > e-mail and any attachments from your system. > > If this e-mail constitutes a commercial message of a type that you no > longer wish to receive please reply to this e-mail by typing Unsubscribe in > the subject line. > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] Aussie Macromedia Developers: > http://lists.daemon.com.au/ -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
