Forum Discussion
Date between
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...
Anonymous , 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])
Anonymous , 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])
Thanks