While preparing myself to the Developer 1 certification I met the following question:
Universal Containers requires a Service Representatives to update all Cases at least once every three days. To make sure this policy is obeyed, a developer has been asked to implement a field that displays the number of days since the last Case update. What should the developer use to configure the solution?
A) Process builder
B) Workflow rule
C) Scheduled Apex Class
D) Formula field
I was very sure when answering that the correct answer is D): I would definitely be able to find the difference between today and the day of the date which is the value of the last Case update field. And hence, I would be able to create a formula field which would help me to configure the solution.
But the correct answer turns out to be A). Could someone explain me why, please?
Here are some more thoughts why I picked the D) answer.
Universal Containers requires a Service Representatives to update all Cases at least once every three days.
1. All Cases will have the formula field, so all Cases will be updated.
2. The formula field expression evaluates every time you query it, so it literally will always be updated (so, the requirement to update all Cases at least once every three days preserves).
3. Your configure the field only once and then it works automatically.