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.

  • For what it's worth, I would have thought D too. Where did you find this question? – Kasper Aug 3 '18 at 10:04
  • @Kasper, the company I am working in helps me to prepare to the exam. I was given questions, answers to them and was asked to research those questions in which I lack knowledge. – iloveseven Aug 3 '18 at 10:09

If you read the question properly, it has been asked to update all cases in a configurable way based on number of days.

So, number of days can be calculated by formula but to meet the requirement of the use case you need to configure Process Builder.

Correct option is A


Here you need to update the cases, so you need to perform DML operation with a configurable way. So based on number of days, you need to configure process to update cases.

Makes sense!

  • I updated the question, so that it was clear why I am asking the following question. Could you, please, point out what part of the requirement does formula field not meet exactly? – iloveseven Aug 3 '18 at 8:02
  • check my updated answer – Santanu Boral Aug 3 '18 at 8:09
  • 1
    Ok. I think I see it now. The point here is that the solution requires not only fields which would display the number of days since the last Case update, but the solution requires the actual update as well. And that is the reason why formula field is not applicable in the problem. – iloveseven Aug 3 '18 at 9:16
  • Basically, should read the question carefully, sometimes we get confused with unimportant thing which has not been asked for. – Santanu Boral Aug 3 '18 at 9:20
  • Where does it say that the solution should update the record? As i read it only the service representative has to do that? – Kasper Aug 3 '18 at 10:03

I think the reason for this is that most case updates are on child objects - case comments, case emails, activities, etc. Therefore you could not calculate this simply with a formula field on the case object. You would need processes on the child object to update a date field on case, which could be used to generate the required information (number of days since update)

I dont read the question as requiring DML on the case itself - just to track how many days since a case has been updated. The question ought to clarify what counts as an 'update' - else the correct answer is unclear.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.