Print this page

Calculation of Case AGE field in Reports

Knowledge Article Number 000232939
Description Case object report display a drop-down list labeled “Units” that let you select the view for Age in days, Hours, or Minutes.

This will give you an option to create a custom Formula field that will calculate the Case Age.
Resolution Below are the information on how the time that has elapsed from its creation to the present in a Case is calculated.

Days - NOW()-CreatedDate 
Hours - (NOW() -CreatedDate )*24
Minutes - (NOW() -CreatedDate )*1440

Below are the details on how to create a custom formula to show the "Non - Rounded up" values in Case object for Age in days , Hours or Minutes:

1) Click on Setup | Customize | Case | Fields | Create New Custom fields | Data type Formula |

      a) Name / Label : Case Age in Hours / Minutes / Days | Click on Next | Choose the Formula options below (depending on your requirements)

      b) "Case Age in Days" : 
               IF (IsClosed,ClosedDate - CreatedDate,NOW() - CreatedDate) or

       c) "Case Age in Hours" :
               IF( IsClosed , (ClosedDate - CreatedDate) *24, (NOW() - CreatedDate ) *24) or

       d) "Case Age in Minutes" 
               IF( IsClosed , (ClosedDate - CreatedDate) *1440, (NOW() - CreatedDate ) *1440)


See Also:

How is the "Age" calculated in case reports?

promote demote