>- see footer for list info -< But in the Access columns I've set the Format to dd/mm/yy, does that stop the need to convert the date to American format
On 07/12/05, dominic watson <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > Try storing the dates the American way, mm/dd/yyyy. > > Then when you want to display them use DateFormat(theDate, 'dd/mm/yyyy') > > Dominic > > Stephen Adams wrote: > > >>- 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 > -< > _______________________________________________ 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 -<
