Forum Discussion

sirsleep29's avatar
sirsleep29
Brass Contributor
Jul 10, 2023

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-project's avatar
    John-project
    Silver Contributor
    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
    • sirsleep29's avatar
      sirsleep29
      Brass Contributor
      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
      • John-project's avatar
        John-project
        Silver Contributor
        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

Resources