I'm working with an accounting database that stores order dates as a varchar (8) field. An example would be "20100420". Obviously, CF's dateformat chokes when used.
Short of using a bunch of cfset statements with CF functions, how can I (in SQL preferrably or CF) easily format this string to "04/20/2010"? Thanks, Che ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333152 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
