[RESOLVED] IsDate question

I'm working on a existing project where displays in a ListView are getting corrupted from a sort routine. This issue is the logic is treating a dollar amount as a date. It basically comes from a check similar to this:

Code:

---

Dim strTestIt As String
strTestIt = "200.00"
If IsDate(strTestIt) = True Then
    MsgBox "Date"
Else
    MsgBox "Not date"  '<== Tests not a date
End If
   
strTestIt = "10.00"
If IsDate(dTestIt) = True Then
    MsgBox "Date"      <== Tests as a date
Else
    MsgBox "No date"
End If

---

It is after "23.00" that VB longer considers it a date. What's going wrong?

Actually TIME is also a date. So any TIME value will evaluate to a valid date with the IsDate function.
I assume it is considering it as a time and hence a valid date.

Pradeep

Quote:

---

Originally Posted by Pradeep1210

Actually TIME is also a date. So any TIME value will evaluate to a valid date with the IsDate function.
I assume it is considering it as a time and hence a valid date.

Pradeep

---

That seems to test out as true right up to "23.59". Thanks!