Details about this thread
  • State Not Answered
  • Replies 3 replies
  • Subscribers 293 subscribers
  • Views 755 views
  • Users 0 members are here
Related content from around SugarClub

Report Date Greater Than

Tyler Martin

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?

Parents
  • 0
    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.
Reply
  • 0
    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.
Children
No Data