function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
madimuliamadimulia 

How to calculate age at current status?

I'm currently trying to create formula to calculate the Age of a case at certain status. So that we would be able to know how long a case has been in "new", "in-progress", or "Waiting", etc.

 

Is anyone know how to do this? I can only calculate Today()-CreatedDate so far.

Any input is very appreciated. Thanks!:)

Best Answer chosen by Admin (Salesforce Developers) 
mpannmpann

Have you had a look at the case history reports?

 

Otherwise you could create some (hidden) date fields for each status and update them with a workflow, when the status changes to that value. You would then use formula fields to calculate the difference between the logically sequential statuses. Bear in mind that your users might revert to or skip a value! 

 

 

All Answers

mpannmpann

Have you had a look at the case history reports?

 

Otherwise you could create some (hidden) date fields for each status and update them with a workflow, when the status changes to that value. You would then use formula fields to calculate the difference between the logically sequential statuses. Bear in mind that your users might revert to or skip a value! 

 

 

This was selected as the best answer
Amber NeillAmber Neill

We use the "Case Age in Business Hours" to track the age of cases.  It lets you specify "Stop Statuses" so that you're tracking only the hours you're open, etc.

Here's the URL: http://sites.force.com/appexchange/listingDetail?listingId=a0N300000016ccNEAQ

Good luck!
Amber