Forum Discussion
MS Project 30 60 90 day lookahead
Hi All,
I am new to Project Management as I have started a new role as a Project Lead and this is all new to me coming from a tester background.
I have been tasked with finding a way on M...
Yas
You can do a 30, 60 day look up
I use this flag and view for a 4 week look ahead
Create a Flag custom field with the following formula (you can change the 4 weeks)
IIf(([Start]>=DateAdd("ww",-1,[Status Date]) And [Start]<=DateAdd("ww",4,[Status Date])) Or ([Finish]>=DateAdd("ww",-1,[Status Date]) And [Finish]<=DateAdd("ww",4,[Status Date])),Yes,No)
didn't work. any hints?