Verify if the expression is convertible into a date format.
SELECT IsDate(Now()); |
The IsDate() function determines if an expression is convertible into a date, returning TRUE (-1) for a valid date and FALSE (0) for an invalid date.
IsDate(expression) |
Parameter |
Description |
expression |
Required: The value to be tested. |
Works in: |
From Access 2000 |
Return TRUE if the expression represents a valid date; otherwise, return FALSE.
SELECT IsDate(“Hello”); |
Return TRUE if the expression can be interpreted as a valid date; otherwise, return FALSE.
SELECT IsDate(“August 25, 2017”); |
Return TRUE if the expression is recognized as a valid date; otherwise, return FALSE.
SELECT IsDate(#25/8/2017#); |