I asked this before, but this time with a different approach (same goal though) After 5 days a case (with a specific record type to avoid the dml limit and also only getting the preferred cases) should get set the status back to open (nothing more) when the LastModifiedDate is greater or equal to 5 days ago.

I created a formula date field which already gives me the correct date in the future

enter image description here

So my idea would be to have an scheduled trigger flow running every day and jus looking for this field. And if the {!$Flow.CurrentDate} value matches the field value then update the case.

Question to all the pros out there: Would that work?

enter image description here

Kind regards Alex

Thanks for the answer so far. I created a record trigger with a scheduled path. Not sure if this is correct:

enter image description here Also some entry filters: enter image description here and a single get item enter image description here When I save it and debug it there is an error message: Nothing is connected to the Start-Element. Which I tend to disagree :) enter image description here

  • 1
    A scheduled flow should work. Jun 26 at 20:22

1 Answer 1


Yes, but technically it could end up missing records in some edge cases. I'd say it'd be more reliable to use a Record Triggered Flow with a Scheduled Path set to either five days after Last Modified Date, or you could even use the formula field you created to make sure it fires either five or seven days afterwards (business days). Alternatively, your Scheduled Flow could just query records directly, rather than relying on a formula, which also involves a full table scan, which may eventually run into other limits.

  • Thank you. Maybe is it possible to elaborate a little on that. I build a path and now get the error message nothing is connected to the start element.
    – Alex M.
    Jun 27 at 9:01
  • Could you maybe have another look?
    – Alex M.
    Jun 27 at 18:44
  • 1
    @AlexM. Yeah, I'll see what I can come up with.
    – sfdcfox
    Jun 27 at 19:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .