variable as a string

Hi Gang, I have a variable as a string Tuesday, June 1, 2004 What I am Trying to figure out is how can I change it to 06-01-2004 Any one can tell me if it can be done and how? JT

DateFormat(yourvar, "mm-dd-yyyy") Aaron Hi Gang, I have a variable as a string Tuesday, June 1, 2004 What I am Trying to figure out is how can I change it to 06-01-2004 Any one can tell me if it can be done and how? JT

When I do that I get this Error The value "Tuesday, June 1, 2004" could not be converted to a date. JT   DateFormat(yourvar, "mm-dd-yyyy")   Aaron   Hi Gang,   I have a variable as a string   Tuesday, June 1, 2004   What I am Trying to figure out is how can I change it to   06-01-2004   Any one can tell me if it can be done and how?   JT

try #createodbcdate(dateformat(yourstringvalue,'mm/dd/yyyy'))#   Hi Gang,   I have a variable as a string   Tuesday, June 1, 2004   What I am Trying to figure out is how can I change it to   06-01-2004   Any one can tell me if it can be done and how?   JT

Have you tried parseDateTime() or lsParseDateTime()? (That's an L not an I)   _____ Sent: Tuesday, 1 June 2004 12:34 p.m. To: CF-Talk Subject: RE: variable as a string When I do that I get this Error The value "Tuesday, June 1, 2004" could not be converted to a date. JT   DateFormat(yourvar, "mm-dd-yyyy")   Aaron   Hi Gang,   I have a variable as a string   Tuesday, June 1, 2004   What I am Trying to figure out is how can I change it to   06-01-2004   Any one can tell me if it can be done and how?   JT   _____  

Thanks Matthew, Just What I was Looking For. JT   Have you tried parseDateTime() or lsParseDateTime()? (That's an L not an I)     _____   Sent: Tuesday, 1 June 2004 12:34 p.m.   To: CF-Talk   Subject: RE: variable as a string   When I do that I get   this Error   The value "Tuesday, June 1, 2004" could not be converted to a date.   JT     DateFormat(yourvar, "mm-dd-yyyy")     Aaron     Hi Gang,     I have a variable as a string     Tuesday, June 1, 2004     What I am Trying to figure out is how can I change it to     06-01-2004     Any one can tell me if it can be done and how?     JT     _____