The IsDate function returns a Boolean value that indicates if the evaluated expression can be converted to a date. It returns True if the expression is a date or can be converted to a date; otherwise, it returns False.
Note: The IsDate function uses local setting to determine if a string can be converted to a date ("January" is not a month in all languages.)
Parameter | Description |
---|---|
expression | Required. The expression to be evaluated |
Legal dates:
The output of the code above will be:
Illegal dates:
The output of the code above will be: