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#); |