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"
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