You passing it a proper date object? or a date string? I find i get all sorts of issues with date strings.
Mark On Thu, 7 Oct 2004 11:08:52 +1000, KNOTT, Brian <[EMAIL PROTECTED]> wrote: > 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/ > -- 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/
