Same Day Case Resolution Report

 Same Day Case Resolution Report


Try this formula:


We may require to change the formula based on time zone (e.g. here I have used US), but this will result in TRUE if either of the following scenarios exist:

1) Case was created < 5pm and closed on the same day(regardless of what time it was closed (before midnight))

2) Case was created > 5pm the previous calendar day and closed the next calendar day(regardless of what time it was closed(before midnight))

 

Formula Data Type = Checkbox

IF(

OR(

AND(

DATEVALUE(ClosedDate) =  DATEVALUE(CreatedDate),

VALUE(MID(TEXT(CreatedDate - 5/24 ), 12, 2)) < 17

),

AND(

DATEVALUE(ClosedDate) - 1 = (DATEVALUE(CreatedDate)),

VALUE(MID(TEXT(CreatedDate - 5/24 ), 12, 2)) > 16

)

)

, TRUE, FALSE)



We can use the formula field as a filter in your report to display the results we want.

Checkbox_Field__c equals TRUE

Comments