Description:
Returns a Boolean value indicating whether an expression can be converted to a date.
Syntax:
IsDate(expression As Variant) As Boolean
Calling:
b = IsDate(expression)
Parameters:
| expression | (Variant) any date expression or string expression recognizable as a date or time |
|---|
Return Values:
true - If the expression is a date or if can be converted to a valid date
false - Otherwise
Note:
In OS Windows, the range of valid dates is from January 1, 100 A.D. to December 31, 9999 A.D. The range vary among operating systems.
Example:
Dim MyDate, YourDate, NoDate, bCheckMyDate = "October 19, 2017": YourDate = #10/19/17#: NoDate = "Hello"
bCheck = IsDate(MyDate) ' Returns true
bCheck = IsDate(YourDate) ' Returns true
bCheck = IsDate(NoDate) ' Returns false