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

VB Code:
  1. If IsDate (strItem) Then

  2.     strItem = Format$(strItem, "dd-mmm-yyyy")

  3. 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 . . . .