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
sirsleep29,
When you say "outside of the date range", what exactly do you mean? Look carefully at what the filter is doing. It does NOT limit the result to tasks that start AND finish in the range, rather, it shows tasks that in completely in the range or that start or finish within the range.
John
When you say "outside of the date range", what exactly do you mean? Look carefully at what the filter is doing. It does NOT limit the result to tasks that start AND finish in the range, rather, it shows tasks that in completely in the range or that start or finish within the range.
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.
JohnHi 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
