bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access IsDate() Function

Example

SELECT
IsDate(Now());

Definition and Usage

The IsDate() function checks whether an expression can be converted to a date.

This function returns a Boolean value. TRUE (-1) indicates that the expression is a valid date, and FALSE (0) indicates that the expression is not a valid date.

Syntax

IsDate(
expression
)

Parameter Values

ParameterDescription
expressionRequired. The value to test

Technical Details

Works in:From Access 2000

Previous

MS Access Environ() Function

Next

MS Access IsNull() Function