AnsweredAssumed Answered

Fixed datetime formula

Question asked by Daphne Lin on Jul 26, 2018
Latest reply on Jul 26, 2018 by Francesca Shiekh

How create a fixed date + time field?

 

I have a field called 'Task completed date' and have the calculated value shown as:

ifElse(equal($status,"Completed"),now(),date(""))

 

I'd like 'Task completed date' to show the date & time that I change the status to "complete". But if I set the formula as above, whenever I change other fields like descriptions, the time will be updated. How to prevent the time be changed and to be fixed as exactly the time I changed the status?

Outcomes