Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Comparing two date fields in report filter

Avatar

Level 6
Level 6

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

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 7

valueformat=atDate to compare only the dates(MM/DD/YY) without the timestamp.

Avatar

Level 6
Level 6

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!