The reason for this is likely to be that the task was completed after the planned completion date (with time taken into consideration). For example, if a task was planned to complete at 16:00 on 01/06/23, but was actually completed at 17:00 on 01/06/23, it is classed as late in Workfront.
You've got a couple of options here. You either align the planned completion date of tasks to always be at the end of a business day. Or, you would need to add a calculated field to each of the tasks that measures the difference in days between actual and planned completion, which can then be used in your report filter.
The calculated field would look something like this: DATEDIFF({actualCompletionDate},{plannedCompletionDate})
Make sure that you set the calculated field to be number format so that it can be used correctly in reports.
Best Regards,
Rich.
Thank you Rich! That's really helpful. I appreciate your help.
