>- see footer for list info -< What does it matter what format the dates are in, in the database?
You add them in with CreateODBCDateFormat(), then you output them in DateFormat(). I can't honestly see you problem, unless you added them in wrong. My 2p worth. Allan -----Original Message----- From: Stephen Adams [mailto:[EMAIL PROTECTED] Sent: 26 January 2006 14:49 To: Coldfusion Development Subject: Re: [CF-Dev] Best way to format dates into an Access DB forUKformatdates >- 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 >-< ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________ 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 -<
