Last updated: August 26, 2026.
The IsDate function returns True when an expression can be recognized as a date or time.
Syntax
IsDate(expression)| Argument | Description |
|---|---|
expression | Value to test |
Examples
IsDate("August 26, 2026")
IsDate("2026-08-26")
ValidDate: IsDate([DateText])Text parsing depends on regional settings. Prefer actual Date values or unambiguous input formats instead of relying on locale-sensitive text.
See Microsoft’s Access function reference for related expression functions.