Print this page

How do I build a workflow rule to update a date field when the record owner is changed?

Knowledge Article Number 000005475
Description

How do I build a workflow rule to update a date field when the record owner is changed?

Resolution
Sometimes it is helpful to be able run a report on all accounts that have changed owners in the past week. This workflow rule will update a date field with the current date when ever the record owner is changed.
 
Here are the steps:
 
1. Create a custom field on the account that is not visible on the page layout. Make sure this is of type date.
 
2. Build a new workflow rule with the following criteria.
 
Object: 
Account
 
Evaluate this rule: 
created, and every time it’s edited
 
Rule Criteria: 
Run this rule if the following formula evaluates to true
 
 
ISCHANGED(OwnerId)
 
 
3. Create a new field update.
 
4. Update the date field you created in step 1.
 
5. The formula value for the update should be:
 
TODAY()
 
 
6. Activate the rule.
 
Anytime the account owner is changed the date field will be populated with the current date.




promote demote