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!
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
valueformat=atDate to compare only the dates(MM/DD/YY) without the timestamp.
Views
Replies
Total Likes
Don't think I can work this into the filter I'm trying to accomplish, but this will be helpful for the calculated column, thank you!
Views
Replies
Total Likes
Views
Likes
Replies