>- see footer for list info -< Thanks, I always thought that it would be possible to enter dates into Access in any format. I hate access, grrrrrr!
On 26/01/06, Niklas Richardson <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > I used the following code to ensure UK date formatting works. > > // set the locale to UK in application.cfm/.cfc > setLocale(......); > > // my query > set myDate = #createodbcdate(lsdateformat(thedate, 'dd-mmm-yyyy'))# > > // outputting > #lsdateformat(myquery.myDate, 'dd/mm/yyyy')# > > The query thing might be a bit over kill but it never failed for me. > > Cheers > > Niklas > > > On 26/01/06, [EMAIL PROTECTED] < > [EMAIL PROTECTED]> wrote: > > > > >- see footer for list info -< > > The dates will always be stored in ODBC format (Yank Style) as far as I > > have ever found out. > > Trust me this really is the best way to store them. As has already been > > said store them this way and convert them locally. > > > > You are heading for loads of grief if you try to store the dates in any > > other way. > > > > I spent ages trying to sort this out and the way described is DEFINATELY > > the best way. > > > > 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 > > -< > > > > > > -- > Niklas Richardson > Prismix Ltd > > UK based Flex and ColdFusion Specialists > _______________________________________________ > > 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 -<
