function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Report on Cases Opened "More than X days" Ago

I need to pull a report (or view) that shows all cases that have been open more than 14 days.  I realize that we can pull a view and sort by the Date Opened ... but the management team would like to pull a report.  Is there a filter that I can pull without hard-coding a date?  Can I put into a report Date Opened is more than 14 days ago?

Best Answer chosen by Admin (Salesforce Developers) 

You can do this in a report or list view.  Use this for your advanced criteria:


Opened Date less than LAST 14 DAYS
AND Closed equals False