IsDate function?

[drmover]

Hello,

Is there any function like IsDate in VB?

If not, how can I validate a text if it's a valid date format?

Thank you,
Elad.

 

[JesseW]

DateTime.DateParse(datestring) will throw an exception if parsing fails, which you could trap with extra coding, but I don't see a method for what your looking for. Perhaps you should suggest it on the Bugs & Wishlist forum? It may be included in one of the third party libraries, but a site search didn't turn up anything.

 

[Erel]

The best approach is to try to parse and catch the error:

Sub Activity_Create(FirstTime As Boolean)
    DateTime.DateFormat = "dd/mm/yy"
    Log(IsValidDate("01/01/2000"))
    Log(IsValidDate("13-12/2007"))
End Sub


Sub IsValidDate(Date As String) As Boolean
    Try
        DateTime.DateParse(Date)
        Return True
    Catch
        Return False
    End Try
End Sub

However, currently the date parser will only throw an error if the string is not formatted correctly. It will not throw an error for "out of range" dates: 35/01/2000

This will be fixed in the next update.