Jun 22 2021 08:42 PM
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
Jun 23 2021 06:44 AM
SolutionYou 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
Jun 23 2021 08:05 PM
Jun 24 2021 07:55 AM
Feb 22 2024 09:50 PM
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
Feb 23 2024 08:42 AM
Jun 23 2021 06:44 AM
SolutionYou 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