Export (0) Print
Expand All
Expand Minimize

IsDate Function

Returns a Boolean value indicating whether an expression can be converted to a date.

                      IsDate(expression)

The expression argument can be any date expression or string expression recognizable as a date or time.

IsDate returns True if the expression is a date or can be converted to a valid date; otherwise, it returns False. In Microsoft Windows, the range of valid dates is January 1, 100 A.D. through December 31, 9999 A.D.; the ranges vary among operating systems.

The following example uses the IsDate function to determine whether an expression can be converted to a date:

Dim MyDate, YourDate, NoDate, MyCheck
MyDate = "October 19, 1962": YourDate = #10/19/62#: NoDate = "Hello"
MyCheck = IsDate(MyDate)   ' Returns True.
MyCheck = IsDate(YourDate)   ' Returns True.
MyCheck = IsDate(NoDate)   ' Returns False.

Community Additions

ADD
Show:
© 2014 Microsoft