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.
Remarks
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.
|