These docs are for v1.0. Click to read the latest docs for v1.2.

ISDATE

Returns true if the specified value is a date value.

Syntax

=ISDATE(value, fuzzy)

Arguments

ArgumentTypeDescription
valueAnyThe value to test
fuzzyBooleanSpecify 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.