Forum Discussion
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
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-projectSilver ContributorJames, You're welcome and thanks for the feedback. If I answered your question, please consider marking my response as the answer.
- John-projectSilver Contributor
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
- Nidhi320Copper Contributor
John-project Hi John, how to create the following?
First create two custom date fields
Date1 = [current date]
Date2 = [current date] +30- John-projectSilver ContributorNidhi320,
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_HeCopper 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-projectSilver ContributorMiss_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
- James_PriceBrass ContributorNice one. Thanks John
James