How to create a report that shows which Cases were closed AND opened in the last 90 days
|Knowledge Article Number||000005307|
Customer wants to create a report that shows which cases were closed in the last 90 days and which case were opened in the last 90 days. Using standard filter customer is able to get either Cases open in the last 90 days or cases closed in the last 90 days.
On the Case object create 2 formula fields with the number data type.
IF(AND(ClosedDate<NOW() ,ClosedDate>(NOW() -90)) ,1,0)
This field displays a 1 if the Closed Date or Created Date is between today and 90 days from today. When you create the report you will put in a filter that says:
Closed Date in the Last 90 Days = 1
Created Date in the Last 90 Days = 1