Dynamic date filter in Resource Usage view

[stct]

Greetings!

I am trying to define a custom filter with following condition in 'Resource' Usage view:

1. Display Not Completed tasks (i.e. %Work Complete < 100%)
AND
2. Start < [Today + 15 days] OR Basline Start < [Today + 15 days]

I first defined custom date fields to capture (Today + 15 days). Then added a Custom filter with above formula in the Resource view..

Results: unfortunately, this showed me tasks with Start and Baseline start date 3 months out..

Can anyone suggest a better way of getting this so that correct data is displayed. Option to avoid customization would also help, if possible to define.

Thank you in advance,

 

[PDQBach]

First of all, you need to know that in the Resource Usage view, the Start and Finish are *not* the Task Start and Task Finish but are, instead, the Assignment Start and Assignment Finish. While these are often the same, they do not have to be the same -- especially when multiple resources are assigned to the same task.

When you are creating your filter, you will need four rows:

1. %WorkComplete < 100
2. And Start < Today+15
3. Or %WorkComplete < 100
4. And Baseline Start < Today+15

Today+15 can be obtained by putting the following in the "Value(s)" column:

"Enter today+15"?

Note: the quotes are required as is the Question mark.

And, yes, you will be prompted twice. (At worst, a minor inconvenience.)

Note that it *is* possible (using VBA) to avoid the prompt by dynamically defining the filter. In this particular case and because you are relatively new to MSProject, I won't bore you with the details.