isDate function
The isDate function checks whether the data type of the attribute specified in the string parameter is date.
Parameters
isDate(string, binary)
Parameter | Description |
---|---|
string | The nominal attribute to be tested. The string parameter is mandatory. |
binary | If it is True, or not specified, results will be provided as Booleans (True/False), while if it is False, results will be provided in binary form (1/0). The binary parameter values (True/False) are case sensitive. |
Date type valid formats (if the values aren’t this format, the function will return a False or 0).
2019/10/12;
12/10/2019;
2019-10-12;
12-10-2019;
2019/Oct/12;
12/Oct/2019;
2019-Oct-12;
12-Oct-2019.
Example
The following example uses the Is functions dataset.
Description | Screenshot |
---|---|
In this example, we want to check if the first attribute is a Date attribute. We add a new attribute, that we will call isdate, and write the following formula to fill it:
We wrote False as we want our results to be displayed in binary form. | |
If you want to delete the outliers, you can apply a filter to the isdate attribute. In this example, as you can see, the value in row 7 of the Date attribute is not a date, so the function has returned a 0. Here, we want to keep only those values which are of Date type, where the function has returned 1. So, drag the isdate attribute onto the Post-filter area and uncheck the 0. Then, click Apply and Make Persistent. | |
This is the final result after having post-filtered the isdate attribute. |