convert string to a date

[TMac42]

My querystring is passing in:

Fri Sep 16 00:00:00 GMT-0500 2005

Is there a fuction that will take this string and convert it to simply give me mm/dd/yyyy?? Otherwise, I'm thinking I'll have to use mid, right, etc. to parse the string.

Thoughts?

 

[FesterSXS]

look at using the CDate() function

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[TMac42]

To use CDate, it must have a date as input. I used IsDate() to check my string value and it is not recognized as a true date. So, I may be stuck with parsing the string... unless anyone else has any ideas. Thanks.

 

[Chopstik]

You might also look at FormatDateTime() function and DateValue() function.

------------------------------------------------------------------------------------------------------------------------
"I am not young enough to know everything."
Oscar Wilde (1854-1900)

 

[Genimuse]

Pretty sure all the date functions like that require actual dates (except the one that asks for parts, which means parsing).

 

[tsdragon]

If you split that string on spaces then it should be easy to pick up the parts you need to create a date or reformat one.

Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.

 

[chmohan]

HTH

http://forums.asp.net/1044914/ShowPost.aspx