+ Start a Discussion
HD ManagerHD Manager 

Possible to have a date field update when a certain field is edited?

There does not appear to be a way to make a custom date field that updates to todays date whenever a field is edited. Does anyone have some insight?

Basically I have a 'Offer Comments' field, and a corresponding 'Offer Comments Date' field that should show the date the Comments field was last edited. How can I implement this? It does not seem possible with the available criteria with a workflow rule.

Any help is appreciated!!
Best Answer chosen by HD Manager
YuchenYuchen
Maybe in your Workflow, you can try the following:

Evaluation Criteria: Evaluate the rule when a record is created, and every time it’s edited
Rule Criteria: ISCHANGED(Offer_Comments__c)

Workflow Actions - Field Update:
Field to Update: Offer Comments Date
Formula Value: today()

The above Workflow will detect a change in the Offer Comments field, then update the Date field with today's date. 
 

All Answers

YuchenYuchen
Maybe in your Workflow, you can try the following:

Evaluation Criteria: Evaluate the rule when a record is created, and every time it’s edited
Rule Criteria: ISCHANGED(Offer_Comments__c)

Workflow Actions - Field Update:
Field to Update: Offer Comments Date
Formula Value: today()

The above Workflow will detect a change in the Offer Comments field, then update the Date field with today's date. 
 
This was selected as the best answer
HD ManagerHD Manager
Thanks Yuchen!