Filtering for anything from "Today"

[D Pingger]

In Project '98 I could filter for dates before today using the excel format
"=TODAY()" or "=NOW()" but it doesn't work for 2003 anymore. Is there another
way to do this other than the interactive way of entering the day? I don't
want my users to have to enter a date if possible.

TIA

Pingger

 

[JulieS]

Hi Pingger,

You could create a formula in one of the flag fields that sets the flag to
"Yes" and then create the filter based upon the flag field.
The flag field formula would be something along the lines of:
IIf([Start]<Now(),"yes","no")

Hope this helps. Let us know how you get along.

Julie

 

[Brian K - Project MVP]

In Project '98 I could filter for dates before today using the excel format
"=TODAY()" or "=NOW()" but it doesn't work for 2003 anymore. Is there
another
way to do this other than the interactive way of entering the day? I don't
want my users to have to enter a date if possible.

TIA

Pingger

You can make Date1 be equal to Now() using a formula and then filter for
tasks whose start is greater than Date1.