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
Post a Comment