I found out why IsDate() is returning true. See the explanation from MS
In your code example IsDate() is interpreting the first 3 digits as a year,
not a month.
Therefore, IsDate("105/11/01") and IsDate("11/01/105") will both return
"IsDate returns True if the expression is a date or is recognizable as a
valid date; otherwise, it returns False. In Microsoft Windows, the range of
valid dates is January 1, 100 A.D. through December 31, 9999 A.D.; the
ranges vary among operating systems"
----- Original Message -----
From: "avivit sa" <avivit@m...>
To: "Code Clinic" <proasp_codeclinic@p...>
Sent: Tuesday, July 31, 2001 1:55 PM
Subject: [proasp_codeclinic] Re: dates validation
> Well, how about the following simple which is not working?
> if not isDate("105/11/01") then msgBox "wrong date"
> I DO NOT GET THE "wrong date" msg!!!
> (If I enter a wrong value in the month (but of course, above 31, as if
> it's a day and not a month) it does work, for e.g: 12/54/01)
> What's going on here? Any idea? Anyone?