Single entry to filter but use over multiple decision pts

[wacntn]

I have a filter as follows.

Actual Finish equals NA and Baseline Finish is less than or equal to "Enter
date"?
OR
Actual start equals NA and Baseline Finish is less than or equal to "Enter
date"?
AND
%Complete is less than 100%

Is there a way to only have to enter the comparison date once but have it
used in more than one place in the filter? This is just an example
filter. I run in to this problem over and over.

Thanks,

Walter

 

[John]

I have a filter as follows.

Actual Finish equals NA and Baseline Finish is less than or equal to "Enter
date"?
OR
Actual start equals NA and Baseline Finish is less than or equal to "Enter
date"?
AND
%Complete is less than 100%

Is there a way to only have to enter the comparison date once but have it
used in more than one place in the filter? This is just an example
filter. I run in to this problem over and over.

Thanks,

Walter

Walter,
There are various ways to handle the multiple input date problem. In
your sample case you might try something like:
Actual Finish equals NA or Actual Start equals NA
AND
Baseline Finish is less than or equal to "Enter date"?
AND
%Complete is less than 100%

Note: I didn't have time to actually check the above but I think you get
the idea.

Another approach is to put the variable date into a spare field (e.g.
Date1) and then use that in the filter.

Yet another possibility may be to use a custom formula instead of a
filter. Depending on the end goal, a formula may be better suited.

Finally, if you know some VBA, it is very easy to built complex
filter/sorting/computational procedures on Project data.

Hope this helps.
John
Project MVP