IsDate

Return TRUE if the expression is a valid date, otherwise return FALSE.

Syntax
      IsDate(expression)

Keyw
   expression    A numeric expression.

The IsDate() function may be used in VBA or in an SQL query.

Examples

Dim boolTest as Boolean
boolTest = IsDate(#1/3/2015#)
Returns True
boolTest = IsDate("January 14, 2014")
Returns True
boolTest = IsDate("SS64")
Returns False

“Superstition sets the whole world in flames; philosophy quenches them” ~ Voltaire

Related:

IsNull - Is expression NULL? True/False


© Copyright SS64.com 1999-2014
Some rights reserved