The Is functions return TRUE if a variable type corresponds to the function call, FALSE is returned otherwise. The required parameter, expression, is the variable whose type status is being determined.
IsDate() checks to see if the string is in a valid date format - it does not check to see if the date actually exists. IsDate("02/30/15") will return True. Additional checking will need to be done in your code to handle different date formats.
Rem Is Functions Example Dim Children(3), Chef, When TestVariable Children Chef = 1 TestVariable Chef When = Now TestVariable When Sub TestVariable(x) If IsArray(x) Then Print "The variable is an array." ElseIf IsDate(x) Then Print "The variable is a date." ElseIf IsNumeric(x) Then Print "The variable is a number." End If End Sub
The variable is an array. The variable is a number. The variable is a date.