Team,
I am trying to add closed date time using calculated field if the status equal to Closed then add the current date time on filed (new filed date time ) (Closed date ).
How can I write the syntax please help...
Thanx
Team,
I am trying to add closed date time using calculated field if the status equal to Closed then add the current date time on filed (new filed date time ) (Closed date ).
How can I write the syntax please help...
Thanx
I believe that this sugarLogic formula may work:
ifElse(equal($status,"Closed"),now(),$closed_date_c)
I believe that this sugarLogic formula may work:
ifElse(equal($status,"Closed"),now(),$closed_date_c)
this one will work but everytime the record is saved or including a formual that relates to another module where a record is edited, the date will be recalculated each time.
I recommend to set this date once the status changes to closed via SugarBPM
Bests
Björn