An API is sending dates in whatever format this is: 2012-04-14T22:58:51-0700
...which does not automagically work with cfprocparam cfsqltype="CF_SQL_TIMESTAMP" (to SQL Server). Before I "roll my own," does anyone know whether that format has a name and/or of a cflib.org function that'll convert it? -- John Bliss - http://about.me/jbliss ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

