Upcoming due tasks in Project

I'm trying to set up a flag or filter in Project to capture upcoming tasks that are not yet done. 

This is the IIf statement I'm using for a custom field. Project accepts the syntax, but returns all fields as a 0. What am I doing wrong? The statement is meant to flag all tasks that are not done and a finish date within the next 7 days.

IIf(([% Complete]<100) AND ([Actual Finish]<ProjDateAdd([Current Date],"+7d")), 1, 0)

T
Tom Boyle 👤 Member for 19 years 6 months

Renzo,

The two expressions on either side of your AND operator are mutually exclusive - a task cannot be incomplete AND still have an actual finish date - so the condition always evaluates to FALSE.  Why not use [Finish] instead of [Actual Finish]?

Good luck, tom 

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