NOW() function -- make it dynamic? Or use in filter "..where start <= now()"????

A

Andy Novak

I have customized the "Date1" field to be equal to NOW() or todays
date via the formula functionality.

I have also created a filter that shows all tasks where start date <=
"Date1" and %Complete is zero.

That is, I want to see all tasks that should have started by today but
have not.

It seems, however, that today (2/16/04), when I inserted the "Date1"
column into my current view of the project data, the date in there was
2/13/04 (last Friday).

It appeared that I had to go back into customize fields, click on
"formula", then OK and OK in order for "NOW()" to be re-set to today.

This is very strange to me. Anything I can do to not have to
reconfirm each time and have MS Project automatically set NOW() to
todays date each time the program is launched and the project file is
opened?

Thanks,
Andy Novak
University of North Texas
 
J

JackD

Have you tried to use Date() instead. I would think that now() would be a
problem as it would constantly have to recalc. Perhaps that is why it is
functionally disabled?

-Jack
 
Top