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.
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)
Retrieving data ...