>- see footer for list info -< Yeah man, don't use Access! Argh! :-S On 26/01/06, Stephen Adams <[EMAIL PROTECTED]> wrote: > > >- 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 > -< >
-- 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 -<
