We're looking to auto increment a number value field on Cases by 1 for every day the case has been open (i.e. auto-increment as long as the case is not closed).

What would be the best way to go about this? A time based workflow action wouldn't get me what I need. I tried a formula field, but, I'm not sure that it would work without referencing the formula field itself.

Does anyone have any ideas?

2 Answers 2


I would simply use a formula field to calculate this. Should be simple enough for calculating Case age regardless of business hours. An example from the salesforce docs:


If you need business hours involved, then a more complex formula is needed like in the link below.



You can create a formula field to do this

IF(IsClosed, ROUND(ClosedDate - CreatedDate, 0), ROUND((NOW() - CreatedDate),0))


You must log in to answer this question.

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