MS Project Tasks Due

[jonathon.levin]

I am having issues writing a custom equation in MS Project that can
put an indicator next to any task that is due from the current date to
+14 days forward. Does anyone have any experience with this?

Thanks In Advance,
Jonathon

 

[Jack Dahlgren]

Answered in the other newsgroup. Please do not post the same question to
multiple newsgroups. It becomes more difficult for people to respond and for
you to find an answer.

-Jack Dahlgren
http://zo-d.com/blog

 

[Jim Erwin]

Sample to start from (local within a project plan - not enterprise):

IIf([% Work Complete]=100,"Completed",(IIf([Finish]<=([Current Date]
+1),"Red",(IIf([Finish]>([Current Date]+1) And [Finish]<=([Current
Date]+7),"Yellow",(IIf([Finish]>([Current Date]+7) And
[Finish]<=([Current Date]+14),"Green","Blue")))))))

I setup graphical indicators with obvious associations, too.
Hope this helps!