Tests whether a string value is a valid date.
Section titled “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
Section titled “Example1”This expression returns true:
IsDate('Jan 1, 99')
Example 2
Section titled “Example 2”This expression returns false:
IsDate('Jan 32, 2005')
Example 3
Section titled “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 )