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 Answer 1

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

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

You must log in to answer this question.

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