MS Access: IsDate Function
In Access, the IsDate function returns TRUE if the expression is a valid date. Otherwise, it returns FALSE.
The syntax for the IsDate function is:
IsDate ( expression )
expression is a variant.
For example:
IsDate (#1/3/2004#) would return TRUE IsDate ("Tech on the Net") would return FALSE IsDate ("January 3, 2004") would return TRUE
VBA Code
The IsDate function can be used in VBA code. For example:
Dim LValue As Boolean
LValue = IsDate("Tech on the Net")
In this example, the variable called LValue would contain FALSE as a value.
SQL/Queries
You can also use the IsDate function in a query.
