Task or Assignment Report showing tasks completed late, excluding time of day

Question

I know that this is a topic that has been discussed a few times but I have yet to find a solution that really works. My goal is to create a report that only shows tasks where the actual completion date is at least 1  day after the planned completion date. The issue I am running into at the moment is that since Workfront utilizes the time of day, instead of just the day, the report is showing tasks that have the same planned and completed dates.  Is there a way to update the below text codes (or a different one) to exclude the time of day or add to it? Something along the line of (Greater than __ + 1 day). I have tried the below to text code for the filter.actualCompletionDate=FIELD:plannedCompletionDate
actualCompletionDate_Mod=gt And in an effort to format late tasks I have tried the text code to the "Actual Completion Date" column. styledef.case.0.comparison.icon=falsestyledef.case.0.comparison.leftmethod=actualCompletionDatestyledef.case.0.comparison.lefttext=actualCompletionDatestyledef.case.0.comparison.operator=gtstyledef.case.0.comparison.operatortype=datestyledef.case.0.comparison.rightmethod=plannedCompletionDatestyledef.case.0.comparison.righttext=plannedCompletionDatestyledef.case.0.comparison.trueproperty.0.name=bgcolorstyledef.case.0.comparison.trueproperty.0.value=eac6c9styledef.case.0.comparison.truetext=

tibormolnar · Accepted Answer

Would it be an option, perhaps, to create a calculated custom field that compares the date part of actualCompletionDate and the date part of plannedCompletionDate, then filter on that custom field?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded