Forum Discussion

James_Price's avatar
James_Price
Brass Contributor
Jun 23, 2021
Solved

MS Project report view tasks in next 30 days...

Hi team 

I want to create an report inside MS Project 2019 that shows upcoming tasks in the next 30 days.  I can see there is a filter for 'Tasks starting soon' but cannot find the filter formula.  My thoughts were to create a new filter where task start >= today and task start< today + 30 but there isn't a function for today.  

Any help gratefully received.

Many thanks 

James 

  • James_Price 

    You can view the construct of the "tasks starting soon" filter by going to, View > Data group > Filter selection box > "tasks starting soon".

    As far as creating a 30 day lookahead filter, here is one way to do it. First create two custom date fields
    Date1 = [current date]
    Date2 = [current date] +30
    Then create this filter:

    John

7 Replies

  • John-project's avatar
    John-project
    Silver Contributor
    James, You're welcome and thanks for the feedback. If I answered your question, please consider marking my response as the answer.
  • John-project's avatar
    John-project
    Silver Contributor

    James_Price 

    You can view the construct of the "tasks starting soon" filter by going to, View > Data group > Filter selection box > "tasks starting soon".

    As far as creating a 30 day lookahead filter, here is one way to do it. First create two custom date fields
    Date1 = [current date]
    Date2 = [current date] +30
    Then create this filter:

    John

    • Nidhi320's avatar
      Nidhi320
      Copper Contributor

      John-project  Hi John, how to create the following?

      First create two custom date fields
      Date1 = [current date]
      Date2 = [current date] +30

      • John-project's avatar
        John-project
        Silver Contributor
        Nidhi320,
        What version of Project are you using? If you don't have the desktop version of Project or Project Online (not Project for the Web) then you won't be able to use the process I outlined above.
        John
    • Miss_He's avatar
      Miss_He
      Copper Contributor

      thank you John-project, that's very helpful.

      I tried with your instructions, and it works for the tasks due within this month. However, the report doesnt show all the tasks meet the criteria. Could you please help on this?

      Many thanks!

      He

      • John-project's avatar
        John-project
        Silver Contributor
        Miss_He,
        I need a little more information. What exactly are you trying to accomplish? A screen shot showing where you think certain tasks aren't being flagged might help.

        John

Resources