IsDate

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

Syntax
      IsDate(expression)

Keyw
   expression    A numeric expression.

The IsDate() function can 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 © 1999-2021 SS64.com
Some rights reserved