Just use this: WHERE expenseDate > <cfqueryparam value="1/1/2006" cfsqltype="cf_sql_timestamp">
Then you don't have to worry about the format and it's also not DB dependent code. Dave Phillips -----Original Message----- From: GLM [mailto:[email protected]] Sent: Wednesday, March 03, 2010 7:14 AM To: cf-talk Subject: RE: problems querying date in access 2007 Thx. I was missing the quotes. I thought that ## replaced the quotes. I just tried it with single quotes inside and out; and double quotes inside and out. and it's the same thing. Inside it stays the same. Outside I get errors (Invalid bracketing) or Data mismatch. I'm missing something simple in the syntax with access 2007. Either that or the data in the table is not formatted correctly but I think the data should be correct. The datatype is: date/time with a format of short date. I added a few rows and typed in some data thinking that this new data would have to be good. But that didn't help. -----Original Message----- From: James Holmes [mailto:[email protected]] Sent: Wednesday, March 03, 2010 2:17 AM To: cf-talk Subject: Re: problems querying date in access 2007 Is your original query actually missing the quotes? Because this: WHERE expenseDate > #1/1/2006# means WHERE expenseDate > 0.000498 mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 3 March 2010 11:05, GLM <[email protected]> wrote: > > I don't use access too often and there appears to be major differences > between 2003 and 2007. I've just wasted the last 2 hours trying to get a > simple query to work. > > > > I'm trying to make a basic query for example: > > > > WHERE expenseDate > #1/1/2006# and < #1/1/2007#. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
