Using the TODAY variable in a custom filter

[Bob B]

For an MS Project 2000 project which has not yet been baselined I want to
create a custom filter to show only tasks which should have started but
haven't.
I've created a custom filter where % complete = 0% and start date is less
than TODAY. Lets say I create the custom filter on 6/26, this filter will
work fine all that day but if I run it on 6/27 it doesn't pick up the TODAY
date because it appears to have hard coded the 6/26 date as the value
criteria!!! Any way round this please?

 

[JulieS]

Hi Bob,

You could insert a custom date ([Date1] for example) and set the formula
for the Date1 field to Now() or [Current Date]. The modify your filter
to reference the Date1 field.

--
I hope this helps. Let us know how you get along.

Julie

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