1

Im trying to create a formula which shows me the Case age. I have following formula which does the right job except its NOT showing the seconds. I tried several ways to include the seconds but i always get error messages.

Can anybody help me and give me some hints on how to add the seconds here?

IF(
    ISPICKVAL( Status , "Open"),
    TEXT(FLOOR((NOW() -  CreatedDate) *24)) &" Hours "& TEXT( ROUND(MOD((NOW()-CreatedDate)*1440,60),0) )&" Minutes ",
    ""
)
1

Hopefully this will solve your issue:

IF(
    ISPICKVAL( Status , "Open"),
    IF(FLOOR( (NOW()- CreatedDate)) > 0,TEXT( FLOOR( (NOW()- CreatedDate)) ) & " days ", "") 
    & IF(FLOOR( MOD( (NOW()- CreatedDate)* 24, 24 ) )>0,TEXT( FLOOR( MOD( (NOW()- CreatedDate)* 24, 24 ) ) ) & " hours ","") 
    & TEXT( ROUND( MOD( (NOW()- CreatedDate)* 24 * 60, 60 ), 0 ) ) & " minutes "
    & TEXT( ROUND( MOD( (NOW()- CreatedDate)* 24 * 60*60, 60 ), 0 ) ) & " seconds", 
    ""
)

It will display the value like this:

19 days 13 hours 7 minutes 53 seconds

For more information about using formula, refer Formula Operators and Functions

  • As a side note - David Litton recently published a Case Age Tracking - unmanaged package. Mire here: salesforcesidekick.com/2017/01/02/… – iDog Jan 4 '17 at 21:23
  • Formula works now perfectly. Thank you both for shared information! – Paul Xinunha Jan 4 '17 at 21:46

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.