Forum Discussion
sirsleep29
Jul 10, 2023Brass Contributor
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 the date range I enter. Anyone have any idea why this would possibly happen?
- 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
- John-projectSilver Contributorsirsleep29,
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- sirsleep29Brass ContributorHi 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- John-projectSilver Contributorsirsleep29,
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