>- see footer for list info -< OK, I've been working on this, and now I can get the date added in UK format on one machine, but as soon as I added the pages to the live server the dates are now still being added in US format. I've checked the regional settings of the server and they are in UK format, but the date is set as US I've also set the locale in Application.cfm as UK. I'm also using LSDateFormat the set the format of the date, but still not they are being saved as mm/dd/yy, but only dates when the day is between 1-12. So on 03/01/2006 it is saved as 01/03/2006, but the 13/01/2006 is saved as 13/01/2006.
Could the problem be drivers for access? I've run out of ideas here. Stephen On 25/01/06, Stephen Adams < [EMAIL PROTECTED]> wrote: > > Hi, > > Thanks for the replies, I'm going to try working on it later today. > > Thanks > > Stephen > > On 25/01/06, Simon Baynes < [EMAIL PROTECTED]> wrote: > > > > >- see footer for list info -< > > Be aware that if you do create a date using createdate( form.year, > > form.month, form.day) make sure you have it in a try catch block as if > > someone chooses the 31st of April for example it will error as it is > > an incorrect date. > > > > On 1/24/06, Salvatore Fusto < [EMAIL PROTECTED]> wrote: > > > >- see footer for list info -< > > > but if you have year, month, day from a submitted form, what do you > > do? > > > 1)createdate(form.year, form.month, form.day ...) > > > 2)createODBCdate(createdate(form.year, form.month, form.day ...)) > > > regards > > > salvatore > > > ----- Original Message ----- > > > From: < [EMAIL PROTECTED] > > > > To: "Coldfusion Development" <[email protected]> > > > Sent: Tuesday, January 24, 2006 6:03 PM > > > Subject: Re: [CF-Dev] Best way to format dates into an Access DB forUK > > > > > formatdates > > > > > > > > > > >- see footer for list info -< > > > > I agree. Always best to use createodbcdate .... Dates can cause you > > REAL > > > > headaches .... > > > > > > > > Regards - Paul > > > > > > > > > > *********************************************************************** > > > > The information contained within this e-mail (and any attachment) > > sent by > > > > Birmingham City Council is confidential and may be legally > > privileged. It > > > > is intended only for the named recipient or entity to whom it is > > > > addressed. If you are not the intended recipient please accept our > > > > apologies and notify the sender immediately, or telephone +(44) 121 > > 464 > > > > 4444 Unauthorised access, use, disclosure, storage or copying is not > > > > permitted and may be unlawful. Any e-mail including its content may > > be > > > > monitored and used by Birmingham City Council for reasons of > > security and > > > > for monitoring internal compliance with the office policy on staff > > use. > > > > E-mail blocking software may also be used. Any views or opinions > > presented > > > > are solely those of the originator and do not necessarily represent > > those > > > > of Birmingham City Council. We cannot guarantee that this message or > > any > > > > attachment is virus free or has not been intercepted and amended. > > > > > > *********************************************************************** > > > > _______________________________________________ > > > > > > > > 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 -< > > > > > > > > __________ Informazione NOD32 1.1376 (20060123) __________ > > > > > > > > Questo messaggio รจ stato controllato dal Sistema Antivirus NOD32 > > > > http://www.nod32.it > > > > > > > > > > > > > > _______________________________________________ > > > > > > 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 -< > > > > > > > > > -- > > Simon Baynes > > www.simonbaynes.com > > _______________________________________________ > > > > 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 -<
