Newbie said:
Hello,
I'm using Project 2003.
How can I set a filter which will test on the Current date of Project ?
Thanks in advance,
Newbie
Newbie,
You can use a filter "value" of "Today" (without the quotes) but that
will simply hard-code today's date into the filter equation and tomorrow
the filter will give yesterday's results.
You can however use another method. Create a custom field (e.g. Date1)
with the formula Date1 = Now(). Then put Date1 as the value in the
filter. The custom field will update automatically, (if calculation is
set for automatic), and when the filter is applied it will use the
current date value.
Hope this helps.
John
Project MVP
