Hi James, Use #createODBCDateTime(datetime)# Since you don't have CF datetime objects, yet, you need to use some regular expressions (or use the Mid function) to extract enough information to create a CF datetime object with #createDateTime(year, month, day, hour, minute, second)#.
-Brent > -----Original Message----- > From: James Matthews [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 6:36 PM > To: CF-Talk > Subject: ODBC Formatting? > > > Hi gang, > > I am inserting an ODBC date into an access database. It is > being stored as > an American formatted date, I need it to be stored in > Australian format. > > American format: 2/6/2002 1:17:26 PM > Australian Format: 6/2/2002 1:17:26 PM > > 6th Feb 2002 > > > I know there is a way to do this, i did it ages ago but i > have forgotten how I > figured that one out...hehe. I believe I stored it in the > format yyyy/mm/dd. > > Any ideas would be appreciated on how to do this. > > James. > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists