isDate

Use the isDate function to check if a Text value contains DateTime value. The isDate function supports ISO 8601 and local formats, or you can define a date format to check for. The function returns a Boolean value.

Function format

isDate(Text date, Text date format)

  • date:the value which is checked for a DateTime type.
  • date format (optional): the customized Date format to check the Text date value for. See Custom date format options.

If you do not define a custom date format, the function first attempts to check the Text date value for a date in the ISO 8601 format. If a date does not exist in Text date in the ISO 8601 format, the function attempts to check the Text date for a date in the local format. See Localized formats.

isDate example

isDate("17/8/2018 1:30:12 am", "DD/M/YYYY, h:mm:ss a")

The formula returns the Boolean value True.