date

[raadwiptec]

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?

[swuehl]

Maybe like

LOAD

     OpeningDate,

     If(IsNum(ClosingDate),ClosingDate,  If(IsNum(OpeningDate),AddYears(OpeningDate,1),AddMonths(LastUpdateDate,15))) as ClosingDate,

     LastUpdateDate,

     ....

FROM ..;

[raadwiptec · Accepted solution]

hi

i found the solution ... i need it in expression basically.. it is if(IsNull(ClsoingDate), Date(AddYears(OpeningDate,1), ClosingDate))