In SQL there is a command ISDATE(YYMMDD) which returns 1 if the parameter is a date and 0 if it is not a valid date.
I am looking for a built in Visual Basic function which will allow me to pass in a 6 character field and return either true or false depending on whether or not the string is a valid date.
Here are a few examples
"770705" => True, This is July 5, 1977
"840010" => False, there is no Month
"000101" => True, This is January 1, 2000
"01B0pH" => False, This is garbage data
If any one can tell me the VB equivalant to the SQL isdate command, I will reward them the points. It is that simple...