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:

isDate($"Date",False)

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.