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

[CoreyMa4]

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=false
styledef.case.0.comparison.leftmethod=actualCompletionDate
styledef.case.0.comparison.lefttext=actualCompletionDate
styledef.case.0.comparison.operator=gt
styledef.case.0.comparison.operatortype=date
styledef.case.0.comparison.rightmethod=plannedCompletionDate
styledef.case.0.comparison.righttext=plannedCompletionDate
styledef.case.0.comparison.trueproperty.0.name=bgcolor
styledef.case.0.comparison.trueproperty.0.value=eac6c9
styledef.case.0.comparison.truetext=

[tibormolnar · Accepted solution]

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?

[CoreyMa4]

That could be a useful calculated custom field. Perhaps if it showed tasks that were completed ahead of the planned completed as -1, -2, -3 etc depending on  how far in advanced they were completed. And tasks completed after the planned completed date as +1, +2, +3 etc.