Forum Discussion
Solved
Date Range Filter
I am trying to use the date range filter in ms project and I put in my dates for let's say a 1 month timeframe but some of the tasks that come back when I run the filter are showing to be outside of ...
- sirsleep29,
The task in your screen shot has a finish date that is "greater than or equal to" today's date. And it's start date is "less than or equal to" 8/11/23. So yup, it's in the date range.
I have always felt the structure of the Date Range filter is confusing, but, it does do what it says.
John
Hi John,
What I am looking to see is an exact range of what is due to start and end for a specific period of time. I set the date range for a month (starting on or after 7/10 and then ending before or on 8/10) and tasks with dates for 2024 and 2025 appear. It should bring up only those tasks that start on or after the start date and then ones that finish before the 8/10 date. It should be pretty cut and dry but it doesnt seem to work correctly for some reason. Thank You
What I am looking to see is an exact range of what is due to start and end for a specific period of time. I set the date range for a month (starting on or after 7/10 and then ending before or on 8/10) and tasks with dates for 2024 and 2025 appear. It should bring up only those tasks that start on or after the start date and then ones that finish before the 8/10 date. It should be pretty cut and dry but it doesnt seem to work correctly for some reason. Thank You
sirsleep29,
Yeah that does seem a little off. By default the Date Range filter does include related summary rows. Are those the areas where you are seeing the 2024 and 2025 dates?
A screen shot could be helpful.
John
Yeah that does seem a little off. By default the Date Range filter does include related summary rows. Are those the areas where you are seeing the 2024 and 2025 dates?
A screen shot could be helpful.
John
Hi John, I set the date range for one month from today until 8/11 and this is one task that comes up. Hopefully you can see the attachment.
- sirsleep29,
The task in your screen shot has a finish date that is "greater than or equal to" today's date. And it's start date is "less than or equal to" 8/11/23. So yup, it's in the date range.
I have always felt the structure of the Date Range filter is confusing, but, it does do what it says.
John- It is most confusing because the second part asks "and before", which makes you think that it is within the one month that you are entering but it isn't true then.
