I'm trying to write a report that shows us records that have been created within the past year, but not modified within the last 30 days. Is this possible with the default reports module?
I'm trying to write a report that shows us records that have been created within the past year, but not modified within the last 30 days. Is this possible with the default reports module?
I am already running the report based on those two values. I want to see filter out records that have a date modified value of over 30 days from today.
I am already running the report based on those two values. I want to see filter out records that have a date modified value of over 30 days from today.
As far as I know there is no way of doing this in the reports. We've been able to do in List View filters by adding a new filter option in the dropdown and some correlated code but I don't see a way to do the same for a report filter.
If you are on Enterprise this could be done in an advanced report by using date_modified <= DATE_SUB(NOW(), INTERVAL 30 DAY)