AnsweredAssumed Answered

Fixed datetime formula

Question asked by Daphne Lin on Jul 26, 2018
Latest reply on Jul 29, 2018 by Harald Kuske

How create a fixed date + time field?


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



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?