ISDATE
Returns true if the specified value is a date value.
Syntax
=ISDATE(value, fuzzy)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Any | The value to test |
| fuzzy | Boolean | Specify whether the test should allow conversion |
Examples
=ISDATE(NOW) → true
Tests whether the current date is a date value.
=ISDATE(DATE(2020, 1, 1)) → true
Tests whether the date January 1, 2020 is a date value.
=ISDATE("2020-01-01T00:00:00", false) → false
Tests whether the date string "2020-01-01T00:00:00" is a date value without fuzzy matching.
=ISDATE("2020-01-01T00:00:00", true) → true
Tests whether the date string "2020-01-01T00:00:00" is a date value with fuzzy matching.
=ISDATE(@"Property 1") → false
Tests whether the shape data property @"Property 1" (123) is a date value.
Updated 6 months ago