Two Weeks Lookahead

S
Sizwe Msomi 👤 Member for 14 years 6 months

Hi all

Please assist in creating a Two week Lookahead on MSP. Date range does not work properly.

 

Regards,

 

Sizwe 

Microsoft Project
A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months
· Permalink

Sizwe,

you could use the following:

a. create 2 custom fields to store the status date and the status date + 2 weeks: Date1 = Date(); Date2 = ProjDateAdd(Now();4800;"Standard") (where 4800 is the number of minutes during 2 weeks according to the usual calendar, and "Standard" the name of the usual project calendar

change these 2 parameters if needed

b. create a task filter that reads: Start >= Date1 AND Start <= Date2

Hope this helps,

Alexandre

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts