Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit is happening now. Discover what's next in customer experience.

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