Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello,
At the moment we do not support > or < operations in formulas for dates. Instead, you can use a formula like this:
if(diff(date_column.asDate("MM/dd/yyyy"), '2018-01-01'.asDate('yyyy-MM-dd'), 'days') < 0, 1, 0)
If your date column has the 'T' in its values, the format for the asDate() parameter will be "MM/dd/yyyy'T'HH:mm:ss.SSSZ
Cheers,
Alexandre
Hello,
At the moment we do not support > or < operations in formulas for dates. Instead, you can use a formula like this:
if(diff(date_column.asDate("MM/dd/yyyy"), '2018-01-01'.asDate('yyyy-MM-dd'), 'days') < 0, 1, 0)
If your date column has the 'T' in its values, the format for the asDate() parameter will be "MM/dd/yyyy'T'HH:mm:ss.SSSZ
Cheers,
Alexandre
It is now possible to use comparison operators for dates:
if(date_column.asDate("MM/dd/yyyy") < '2018-01-01'.asDate('yyyy-MM-dd'), 1, 0)
Or if date_column is already correctly parsed using the "Parse date" step:
if(date_column_parsed.asDate() < '2018-01-01'.asDate('yyyy-MM-dd'), 1, 0)
Cheers
Mehdi