Expand my Community achievements bar.

late task report

Avatar

Level 5

i am trying to run a report that will show tasks late after 5 min past planned start time. i got the late part but can't get the plus 5 min part.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10

Hi Michelle,

One approach I've used is to create a calculated date parameter (e.g. "Five Minute Cutoff") on the tasks that adds five minutes to the planned completion date using ADDDAYS(Planned Completion Date,(5/(24*60))), then filtering (and or conditionally formatting) for those tasks that are not yet complete and whose Five Minute Cutoff is < $$NOW.

Regards,

Doug