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)
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