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.