Tuesday 23 July 2013

Formula field to capture Record/Case Age in Days ,hour and Minutes in Sales force

Here is the formula for Capturing age of record in Days Hours and Minutes.

Text(FLOOR(NOW() - CreatedDate)) &" "&"day(s)" &" "&Text(FLOOR(MOD( (NOW() - CreatedDate) * 24 ,24))) &" "&"hrs"&" "&Text( FLOOR(MOD(((NOW() - CreatedDate) * 24)*60 ,60)))&" "&"min"

No comments:

Post a Comment