/
IS_DATE()

IS_DATE()

Owned by Pedro Jose Sanchez Luling
Last updated: Apr 02, 2025
1 min read
Prototype
IS_DATE(date, [format])

Verifies if a string has date format (yyyy-mm-dd) and is a valid date (for example 2019-02-30 is not valid because February does not have 30 days)

Partial dates are allowed depending on the format value. See examples below

Input parameters

Parameters

Type

Default

Required

Description

Parameters

Type

Default

Required

Description

date

String

 

Yes

Date to verify

format

String

"D"

No

Units in which date is expressed. Accepted values are:

  • "D": require full date ("yyyy-mm-dd")

  • "M": require at least until month part ("yyyy-mm" or "yyyy-mm-dd")

  • "Y": require at least until month part ("yyyy", "yyyy-mm" or "yyyy-mm-dd")

If no format is specified, then "D" is the default value

Return value

Type

Description

Type

Description

Boolean

  • 0: the date is invalid

  • 1: the date is valid

Execution

Always. Calculated on-the-fly whenever an ITEM of a FORM is changed (by means of form_set_answer(), or when the FORM is opened

Examples

Formula

Description

Formula

Description

IS_DATE("2019-05-12")

No UNIT specified, so "D" is assumed. Result = 1

IS_DATE("2019-05-34")

Invalid date because day 34 is not possible. Result = 0

IS_DATE("2019-05", "M")

Required date with at least month part. Result = 1

IS_DATE("2019-05-12", "M")

Required date with at least month part. Result = 0

 

 

Related content