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.
Example1:
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