So if end date is 3/8/208 when the record is created, the check box should be false.
If user modifies the end date on that record to 3/9/2018, the check box should be TRUE.
I've tried a few formulas, but none of them are giving me what I am trying to do.
Any help would be greatly appreciated.
5 件の回答
Hi,
Formula field won't help here because formula field doesn't capture the old value of the fields.
You should write a workflow rule with a field update.
1. Create workflow rule.
2. Create field update.
Please find below some screenshots that might help, make sure you choose the same options as shown in screenshots. You should use Insert Field button to use the accurate date field. And please don't forget to activate the workflow rule at the end.
