Jim Rathmann wrote: > I thought I posted this question yesterday but it doesn't seem that it ever > was posted. > > The question is how to convert this date/time field that I receive in a > webservice to a standard date/time. > > The value I pull is in this format: "2005-04-07T13:29:00.0000000-04:00" > > You cannot use the DateFormat in ColdFusion on it without getting an error > saying it is not a valid dateformat.
CF doesn't recognize ISO formatted dates, that is a long standing enhancement request: http://www.macromedia.com/go/wish/ With simply dropping sub-second precision and the timezone info: cfdate = ListFirst(Replace(theDate,"T"," "),".") Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206609 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54