May not be the most efficient way but: CreateDate(MID(myString,5,2), MID(myString,3,2), MID(myString,1,2))
-----Original Message----- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Friday, June 15, 2007 12:05 PM To: CF-Talk Subject: converting a string to a date - most efficient way? So, I have a file that I am uploading that contains a string that represents the date, and I need to extract the date from the filename. I have the extraction down to a string that looks like MMDDYY (ex: 120507) and I need to turn that into an ODBC date in the most efficient way possible. I've got a few ideas, but they all basically suck. Any takers? -- Ray Champagne Web Developer, Dolan Media Company 612.215.6497 :: 612.718.8852 (m) ray.champagne [at] dolanmedia [dot] com GTalk: raychampagne ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
