Damien Pochon

Adding an "older than x days" filter

Discussion created by Damien Pochon on Mar 7, 2018
Latest reply on Mar 8, 2019 by Brad Foster

Dear all,


I'm curious if any of you ever came across a customer needing to filter his records based on an "older than x days" condition and how you solved it? 

Typical example: Opportunities with close dates older than 7 days, last interaction older than 30 days etc. 

The operator would be used in list views, dashlets and reports. 


I've found the blog posts indicating how to build filters, but I suspect this will not work with reports. 

Maybe a calculated field that would flag the record?