IsDate problems

[Andy Holliman]

Why does IsDate("01 02 03 12 2003") return true and CDate("01 02 03 12 2003") return "1 12 2003" ?

Thanks Andy

 

[EricJ]

is date checks an object to c if it is a date (true or false)
cdate (convert to date) converts a string (object) to a date if possible

eric
Why does IsDate("01 02 03 12 2003") return true and CDate("01 02 03 12 2003") return "1 12 2003" ?

Thanks Andy

 

[Andy Holliman]

Sorry the quaestion wasn't clear - the problem is that the string "01 02 03 12 2003" doesn't look like a date so why is it parsed as if it is?

is date checks an object to c if it is a date (true or false)
cdate (convert to date) converts a string (object) to a date if possible

eric
Why does IsDate("01 02 03 12 2003") return true and CDate("01 02 03 12 2003") return "1 12 2003" ?

Thanks Andy

 

[Armin Zingler]

Why does IsDate("01 02 03 12 2003") return true and CDate("01 02 03
12 2003") return "1 12 2003" ?

Isdate/Cdate is very flexible in interpreting the string. Have a look at the
comments section in the documentatin of the Datetime.Parse method. If you
don't like the behavior, you could use the Datetime.parseexact function
instead.

--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html