+ Start a Discussion
TMangoTMango 

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) 
flewellsflewells

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