Another method would be to do this...
<cfset Day = Day(string) />
<cfset Month = Month(string) />
<cfset Year = Year(string) />
But if it is stuffing up the dates like this
01/02/2005 and its becoming 02/01/2005
Then your best bet would be to do this as the above will still have the same
problem
<cfset SetLocale("English (Australian)")>
<cfset curDate = LsDateFormat(string, "yyyy/mm/dd")>
<cfset newDate = CreateODBCDate(curDate) />
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/
