How do I filter for late tasks without putting in a date ?

[Kraftymiles]

Hi there
I wish to set up a filter that gives late/overdue and incomplete tasks but I
dont want to put todays date in. I've tried finish = greater than baseline
finish but as we have re-planned this brings up tasks that arent even due
yet.
Hope that makes sense, would love some help
Caroline

 

[Gérard Ducouret]

Hi Caroline,
I'm not sure what you want, but I think you will have to run a small VBA
procedure to read the date on your computer.
First, create a filter named "Late Tasks" for ex:
Field Name = Stop
Test = is less than
Value = "Today"?
And
Field Name : % Complete
Test = is less than
Value = 100

In a VBA module (Alt)+(F11), copy the following procedure:

Sub TrackLateTasks()
FilterApply Name:="Late Tasks", Value1:=Date
End Sub

Then you can assign this procedure to a button in any tool bar
Hope this helps,

Gérard Ducouret

 

[Jim Aksel]

You are going to need to input some date... you can't be late unless you
compare to something else. Input a Status Date (Project/Project
Information...)

Insert the Status column. Tasks that are late will be labeled as such.
Read the help on Status for additional information
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project