Hmmm, that subject line could be easily misconstrued. Perhaps using ListGetAt(), CreateDate() and CreateODBCDate()?
<cfset newDate = CreateODBCDate(CreateDate(ListGetAt(date, 3, "/"), ListGetAt(date, 2, "/"), ListGetAt(date, 1, "/")))> Regards, Jon On Wed, 23 Mar 2005 12:00:33 +1100, rob shaw <[EMAIL PROTECTED]> wrote: > 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/
