Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to do this in expression.
I have 2 columns Opening Date and closing Date, Lastupdatedate
I need to Add 1 year to an existing date column .. for ex: I So for a condition if closing date is null then take the date from opening Date and Add 1 year.
2 condition - If opening Date is null then take the date from Lastupdatedate and add 15 months.
any suggestions?
hi
i found the solution ... i need it in expression basically.. it is if(IsNull(ClsoingDate), Date(AddYears(OpeningDate,1), ClosingDate))
Maybe like
LOAD
OpeningDate,
If(IsNum(ClosingDate),ClosingDate, If(IsNum(OpeningDate),AddYears(OpeningDate,1),AddMonths(LastUpdateDate,15))) as ClosingDate,
LastUpdateDate,
....
FROM ..;
hi
i found the solution ... i need it in expression basically.. it is if(IsNull(ClsoingDate), Date(AddYears(OpeningDate,1), ClosingDate))