+ Start a Discussion
Carrlos BoydCarrlos Boyd 

Add an 'end date' when selecting a certain 'status'

I have two fields: Status__c and Function_End_Date__c. If status equals "Completed" or "Cancelled" I need a rule that sets the Function_End_Date__c to the current Date/Time.
Best Answer chosen by Carrlos Boyd
Hi Carrlos,

Your requirement can be achieved using workflow rule and Field update associated with it.
Please create Worklflow Rule and Field Update as shown in below images. I am assuming Datatype of Function_End_Date__c is Date , if it is Date/Time then just Update Field update Formula to NOW().
User-added image
Field Update:
Please mark as best answer if helped.