Re: Date parsing and formatting...

2008-06-19 Thread Ryan Paulson
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

Re: Date parsing and formatting...

2008-06-18 Thread James Holmes
Di you try ParseDateTime() ? On Thu, Jun 19, 2008 at 9:26 AM, Rick Sanders [EMAIL PROTECTED] wrote: 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

Re: Date parsing and formatting...

2008-06-18 Thread Paul Hastings
Rick Sanders wrote: How can I change it to 05/21/2008 ? cfscript t=May 21, 2008; tt=parseDateTime(t); writeoutput(#dateFormat(tt,'mm/dd/')#); /cfscript Please help and let me know if there is a way to convert this date type in to a date string. it already is a date string. you need to

RE: Date parsing and formatting...

2008-06-18 Thread Rick Sanders
Holmes [mailto:[EMAIL PROTECTED] Sent: June-18-08 10:36 PM To: CF-Talk Subject: Re: Date parsing and formatting... Di you try ParseDateTime() ? On Thu, Jun 19, 2008 at 9:26 AM, Rick Sanders [EMAIL PROTECTED] wrote: OK, here's the scoop... I'm grabbing the date from an XML web service which

Re: Date parsing and formatting...

2008-06-18 Thread James Holmes
: June-18-08 10:36 PM To: CF-Talk Subject: Re: Date parsing and formatting... Di you try ParseDateTime() ? On Thu, Jun 19, 2008 at 9:26 AM, Rick Sanders [EMAIL PROTECTED] wrote: OK, here's the scoop... I'm grabbing the date from an XML web service which is returning the date