If-else condition formula help

[Anonymous]

Hi,

I have a below table.

Stage_Name        Closedate

 Close Won           11/30/2016

 Close Lost           03/05/2016

 Active                 10/06/2017

so I have to write a condition in my Tmap that if my stage_name= Close Won or Close Lost , then Closedate = 01/01/2018 else keep same value of closedates.

How do I put that condition in tmap..?

[Shettydatta]

Put an expression as 

! Stage_Name.equals("Active") ? "01/01/2018" : Closedate 

[manodwhb · Accepted solution]

!row1.Stage_Name.equals("Active") ? "01/01/2018" : row1.Closedate