\<bookmark_value\>IsDate function\</bookmark_value\>

IsDate Function

Tests if a numeric or string expression can be converted to a \<emph\>Date\</emph\> variable.

Syntax:


IsDate (Expression)

Return value:

Boolean

Parameters:

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

Error codes:

5 Invalid procedure call

Example:


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

Please support us!