Date between

[m92240]

Hello to all,
I would like to create a column in my table with a condition:
If the due date (Date d'échéance) is between "2020/10/01" and "2020/12/31", and Amount (Montant)> 0, then date = "2021/01/01".

I can't do that...

[amitchandak · Accepted solution]

@m92240 , a new column

New date  = if( [Due Date] >= date(2020,10,01) && [Due Date] <= Date(2020,12,31) && [Montant] , date(2021,01,01), [Due Date])

[m92240]

Thanks