>- see footer for list info -< Hi Stephen, I have had this issue before, you need to make sure that CF is passing the date information in the correct (i.e. UK format) as opposed to US format, have a think about the dates you are entering and see if the month and day were reversed would this explain the answers.
LSDateFormat etc and locale might be the first place to check. Lee Fortnam -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Adams Sent: 07 December 2005 15:22 To: [email protected] Subject: [CF-Dev] returning records that are between dates. >- see footer for list info -< Hi, I'm creating a mini helpdesk site, which records when calls are opened and closed. So in my Access database behind it I have two columns, one that records the date a call is open and one that records when a date is closed. Both of these columns are date/time columns with a format of "dd/mm/yy". So when I try to query the table to a get a list I have been using: WHERE DateOpen > <cfqueryparam cfsqltype="cf_sql_date" value="#DateFormat( arguments.startDate, 'dd/mm/yy')#"> AND DateClosed <= <cfqueryparam cfsqltype="cf_sql_date" value="#DateFormat( arguments.endDate, 'dd/mm/yy')#"> But when I run this query I get some results that are out side of the date I've entered, so I'm not sure that it is the best way to check between dates? Is there another way that will give better results? Thanks Stephen _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
