IsDate Function [Runtime]

From LibreOffice Help
Jump to: navigation, search

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

Syntax:

IsDate (Expression)

Return value:

Bool

Parameters:

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

Example:

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