IsDate Function

Aaaggghhh IsDate("0.00") = True!!!! Pain in the arse . . . .

VB Code:

If IsDate (strItem) Then
    strItem = Format$(strItem, "dd-mmm-yyyy")
End If

if strItem is a numeric string ie "0.00", "1.5" etc. then this returns a true. I assume that this is because it's interpreting it as the number of days since 31-dec-1899.

Pain in the arse, what use is a validation function that only fails non-numeric characters?

Rant over . . . .

My problem is similiar :-

IsDate("31 06 02") returns true (too many days in month).

The problem is that VB adopts the 31 as the year and converts string to 02 06 1931.

I'm investigating the
Day()
Month()
Year()

functions. If there is a public function published somewhere I've yet to find it.

:eek: