late task report | Adobe Higher Education
Skip to main content
M
MichelleBo3
Level 4
May 5, 2020
Vraag

late task report

  • May 5, 2020
  • 1 reactie
  • 449 Bekeken

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.

    Er kunnen geen reacties meer worden geplaatst op dit onderwerp.

    1 reactie

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    May 5, 2020

    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

    ForumvoorwaardenAccessibility statement

    Loading footer...