IsDate Function

Syntax:

IsDate(expr)

Group:

Variable Info

Description: Returns the True if expr is a valid date.

Parameters:

Parameter

Description

expr

A variant expression to test for a valid date.

Example:

Sub Main
  Dim X As Variant
  X = 1
  Debug.Print IsDate(X) 'False
  X = Now
  Debug.Print IsDate(X) 'True
End
Sub

See Also:

TypeName, VarType