DateTime difference in Salesforce Report Formula
To find the Date Time difference in Salesforce Report Formula, use the DATEVALUE(). Sample Salesforce Report Formula: IF( ISNULL(CLOSED_DATE), DATEVALUE(NOW()) - DATEVALUE(Case.Completed_Date__c), DATEVALUE(CLOSED_DATE) - DATEVALUE(Case.Completed_Date__c) ) As per the above ....