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/

Reply via email to