Skip to main content
Hi All,

 

I have a Task Age which is of the type: Formula (Text). The formula is pasted below.

 

IF(IsClosed, Text(FLOOR(ClosedDate__c - Opened_Date_Time__c)) &" "&"day(s)"&" "&Text(FLOOR(MOD( (ClosedDate__c - Opened_Date_Time__c) * 24 ,24))) &" "&"hrs"&" "&Text( FLOOR(MOD(((ClosedDate__c - Opened_Date_Time__c) * 24)*60 ,60)))&" "&"min", Text(FLOOR(NOW() - Opened_Date_Time__c)) &" "&"day(s)"&" "&Text(FLOOR(MOD( (NOW() - Opened_Date_Time__c) * 24 ,24))) &" "&"hrs"&" "&Text( FLOOR(MOD(((NOW() - Opened_Date_Time__c) * 24)*60 ,60)))&" "&"min")

 

This works well with Open Tasks regardless of stage and displays the Task Age in Days, Hours and Minutes e.g. 2 day(s) 20 hrs 54 min.

 

When the Task is however closed and the Status changed to "Completed" the Task Age field only displays this result: day(s) hrs min. This is the same on the page layout and in reports...all I see is day(s) hrs min. 

 

Can anyone suggest how I can get the values of closed Tasks to display correctly? Thank you.
4 件の回答