IsDate Function [Runtime]

From LibreOffice Help
Jump to: navigation, search

Tests if a numeric or string expression can be converted to a Date variable.


IsDate (Expression)

Return value:



Expression: Any numeric or string expression that you want to test. If the expression can be converted to a date, the function returns True, otherwise the function returns False.

Error Codes

5 Invalid procedure call


Sub ExampleIsDate
Dim sDateVar As String
    sDateVar = "12.12.1997"
    Print IsDate(sDateVar) ' Returns True
    sDateVar = "12121997"
    Print IsDate(sDateVar) ' Returns False
End Sub