Seeking some input on comparing dates in a report filter.
Basically I have a calculated column that displays a message if the DATEDIFF between the Task's plannedStartDate and the Project's plannedStartDate is greater than 5 days. However, my filter for the report brings in all tasks where the Task's plannedStartDate is not equal to the Project's plannedStartDate. Since both the date and time are used for these dates, I'm getting more results than I'd like (for example, the Task plannedStartDate is April 3, 2025 at 9:00AM and the Project plannedStartDate is April 3 2025 at 9:15AM. What I really want is to update the report filter to match my calculated column - so only instances where there is a difference of 5 days or more.
Any suggestions on how to make this work? I've explored using calculated fields to accomplish this but I'm not willing to go that route at this time. Thanks all!