Re: CF date values in Access

>>#dateformat(FORM.start_date, "MM/DD/")# Several things here: 1) dateFormat needs a date in its first argument, so CF will first convert FORM.start_date, which is a string, to a date value. 2) thus CF will suppose that FORM.start_date is in american format. But then dateformat is useless si

RE: CF date values in Access

#dateformat(FORM.start_date, "MM/DD/")# should be #createODBCDate(form.start_date)# Or use cfqueryparam. Regards Dale Fraser http://learncf.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 16 November 2007 7:33 AM To: CF-Talk Subject: CF dat

RE: CF date values in Access

Maybe try using a cfqueryparam: .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 15, 2007 3:33

Re: CF date values in Access

> Shouldn't this be working? > 21 : where promotionalID = 85 AND DateReceived >= > #dateformat(FORM.start_date, "MM/DD/")# > 22 : AND DateReceived <= #dateformat(FORM.end_date, "MM/DD/")# > > 23 : No. Though I am surprised its causing a syntax error. A better way to compa