Overdue Tasks

Question

We are aware that overdue tasks are highlighted with a colour in Sugar, however we want to create a report ()that can be used on a Dashboard as well) that shows overdue tasks by assigned user.

We thought this would be easy until we looked at the filter options - there is no ability to specify before today - you can specify before today being todays date but tomorrow the report is wrong because it is now using before yesterdays date.

We considered creating a calculated Overdue field with a formula where if due date is before today, set the field to Yes, but the problem with that is that the calculated field won't update unless the record is accessed and saved.

We looked at List view - nope same filter options.

We also know we probably could build a workflow that triggers the user and the users manager to action the task. Thats fine as well.

And Yes - in an ideal world there should not be any overdue tasks, but in reality it happens.

All we want to do is create a simple Overdue Tasks Report (and maybe later on Overdue Calls and Meetings). Any ideas appreciated, without telling us we need to buy some further add on.

Hopefully we are missing the obvious, because this is pretty basic.

Greg Barrass · Accepted Answer

Hi Greg Barrass , Would use of the filter "Task > Due Date Last # Days" or any of the other "Last" filters work to serve your use case? The MySQL WHERE clause for a report filtered on Last 7 Days, run on Aug 16, looks like this: WHERE ( ( ( tasks . date_due >= '2019-08-10 00:00:00' AND tasks . date_due <= '2019-08-16 23:59:59' ) ) ) AND tasks . deleted = 0 The two issues with this I see impacting your stated use case are: This report returns Tasks due later today, and therefore not yet overdue. This report does not show Tasks due prior to the defined window of time. I hope this helps.