>- 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 -<
