IsDate
The IsDate() function determines whether a given element represents a valid date.
Related functions: IsElement, IsNull, IsDefined, IsNullOrEmpty
Syntax:
IsDate(Element)- In the Quintessence Editor (Studio) using Python language, use:
Qx.IsDate()
ⓘ See parameter descriptions
| Element | Any input value to be tested. |
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Check if each value in an array is a date
Range:
| 12/23/2014 |
| -1 |
| ABCD |
| FALSE |
| (Blank cell) |
| 46001 |
Formula:
return := IsDate(Range)Result:
| TRUE |
| FALSE |
| FALSE |
| FALSE |
| FALSE |
| FALSE |