Report Date Greater Than

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?

0 Rolustech Support over 4 years ago

Hi Tyler,

Sugar typically has both "Record Create Date" and "Record Modified Date" which it stores in the database for each record. You can choose to make that visible on the Record View or List View as well.

Similarly, you can choose to run a report based on these two fields. Set the appropriate "Record Create Date" and "Record Modified Date" values in the report and you'll have your desired result-set.

Hope this helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tyler Martin over 4 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Shad Mickelberry over 4 years ago in reply to Tyler Martin

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)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel