Damien Pochon

Adding an "older than x days" filter

Discussion created by Damien Pochon on Mar 7, 2018
Latest reply on Mar 14, 2018 by Constantine Shpikat

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? 

Outcomes