There is probably a trick i don't know, but something like... dTemp=createODBCDate(mid(date,3,2)&right(date,2)&left(date,4)) sDate=dateFormat(dTemp,"m/d/yyyy")
On 8/8/07, Scott Stewart <[EMAIL PROTECTED]> wrote: > Convert 20060523 > Into 5/23/2006 > I'm at a loss. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4