> MSSQL 2005 > I figured a db convert statement might be needed? Yes, that is one way to do it. If you think you will be doing it frequently, you could create a "view" (containing the convert) and call the view in your CF code:
SELECT convert(datetime, YourVarcharCol, 112) AS ConvertedToDateTime .... http://msdn.microsoft.com/en-us/library/ms187928.aspx ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:333156 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
