1

Can someone help us what would be the formula for the following:

  1. Elapsed date since the case was created.
  2. Elapsed day and time since the case was created.

Thanks

2

Create Text based formula field and use following formula.

Elapsed date since the case was created.

IF(FLOOR( (NOW()- CreatedDate)) > 0,TEXT( FLOOR( (NOW()- CreatedDate)) ) & " days ", "")

It will display the value like this:

19 days

Elapsed day and time since the case was created.

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
|improve this answer|||||
  • hi @santanu, what if we want to remove the weekends on the date/time computation? – lone Jun 2 '17 at 14:39
  • then better to use business hours, as formula is very fragile, you can post as separate question – Santanu Boral Jun 2 '17 at 14:41

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.