If the code from the other posts did not work you most likely have a bad character in the string. Loop through each character in the string and use asc() to see what it is. For example if there is a chr(13) in the middle of the string it will throw the error you reported.
>OK, here's the scoop... > > > >I'm grabbing the date from an XML web service which is returning the date in >the following format: May 21, 2008 > >How can I change it to 05/21/2008 ? > > > >Naturally I had to parse it to a string because Cold fusion won't parse an >XML child node. > >I've tried dateformat, CreateDate, LSParseDateTime and they all return >errors telling me that "May 21, 2008 is an invalid date format". > >Please help and let me know if there is a way to convert this date type in >to a date string. > > > >Thanks, > > > >Rick Sanders > >Webenergy > >Canada: 902-431-7279 > >USA: 919-799-9076 > >Canada: www.webenergy.ca > >USA: www.webenergyusa.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
