Those other ways are probably better. My first thought would be to find the first / and grab everything to the left, then find the second / and grab everything to the right, then grab everything between the two and then you can make a date with the three variables. Not sure on the syntax, but I think it can be done.
Chad who is married and doesn't need to worry about dates 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/ --- 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/
