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!
Hi !
I'm trying to flag rows using a formula comparing a date column with the result of an "inc" function. While the documentation states that "The comparison operators (and only them) can operate on dates.", my formula does not get me any result although it is correct.
DATSAI >= inc(DATE_CALCUL,-1,"year").
The only way I found around it is creating a new column containing the result of my "inc" function but it requires me to create a column everytime I want to add or cut from my date...
Can you help me use the inc function in the formula please ?
Thank you in advance
Hi @JBaesen ,
Have you tried to wrap that with asDate?
https://doc.dataiku.com/dss/latest/formula/index.html#avoiding-auto-typing
asDate(order_date) >= inc(order_date,-1,"years")
Hi @JBaesen ,
Have you tried to wrap that with asDate?
https://doc.dataiku.com/dss/latest/formula/index.html#avoiding-auto-typing
asDate(order_date) >= inc(order_date,-1,"years")
Hi @AlexT ,
Thanks for your answer, worked like a charm ! ๐
Hadn't thought about it because my column was already a date but as long as it works !