Try
<cfset SetLocale("English (Australian)")>
<cfset curFieldContents = LsDateFormat(now(), "yyyy/mm/dd")>
Regards
Andrew Scott
Technical Consultant
NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205
Phone: 03 9686 0485 - Fax: 03 9699 7976
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of rob shaw
Sent: Wednesday, 23 March 2005 12:01 PM
To: CFAussie Mailing List
Subject: [cfaussie] i have a dates that wont play :(
ok the date is coming out the csv like
21/3/05 or 2/3/05
anyways mysql and coldfusion are stuffing up the dates even with
createodbcdate!
soo i was wondering was there a way i can strip it down to 21 3 05 and then
do createodbcdate(2005, 3, 05)
thank you very much
Rob.
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe
send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/