How to report on dates 'greater than xx days' please?

Trying to see if there is a way to create dynamic reports for sales dashboards based on date fields to display 'greater than xx days'.

I naturally assumed this was possible and common requirement, but can't find a way to do this using Sugar reports, only Advanced reports which cannot be added to Dashboards and not easy for users to choose their own xx days.

Any ideas welcome.

Parents

0 Francesca Shiekh 25 days ago

Probably not the cleanest solution, but your could have a custom scheduler (BPM?) that calculates and updates a custom integer field days_since_xx_date (whatever date you are trying to report on) and then use days_since_xx_date > 5 (for example) in your report.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Francesca Shiekh 25 days ago

Probably not the cleanest solution, but your could have a custom scheduler (BPM?) that calculates and updates a custom integer field days_since_xx_date (whatever date you are trying to report on) and then use days_since_xx_date > 5 (for example) in your report.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data