Function reference

Tests whether a string value is a valid date.

IsDate ( datavalue )

Argument Description
datavalue A string whose value you want to test to determine whether it is a valid date

Data type: Boolean
Returns true if datavalue is a valid date and false if it is not.

This expression returns true:
IsDate(‘Jan 1, 99’)

Example 2:
This expression returns false:
IsDate(‘Jan 32, 2005’)

Example 3:
This expression returns a day number or 0.
If [data] contains a valid date, the expression returns the number of the day, and otherwise returns 0:

If( IsDate( ‘[data]’ ) , DayNumber( Date(‘[data]’) , 0 )

Last modified: 23 May 2021