[RESOLVED] IsDate question

[TysonLPrice]

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:

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?

[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

[TysonLPrice]

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!