NOW() function within formula not automatic???

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

Jeff Fenbert

I have not used the Now() function in the customize
fields. You could accomplish the same thing via a macro.

If you put this macro in the autoopen it would work.

for each t in activeproject.tasks
if not t is nothing
t.date1 = activeproject.currentdate
end if
next t

You could also do it using just the filter. Bring up the
edit filter function. In the first line put in the
following
Field: Start, Test: less than or equal to value: "Today:"?
For the next line select And, Field: %complete, test:
equals and value: 0. This filter will bring up a input
box each time you select it. Put in Today's date and it
should give you the information you want. You would not
have to fill in the date1 field.
 
B

Brian K - Project MVP

Andy said:
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
Click to expand...

Do you have the Calculation option set to manual in the Tools | Options
| Calculation tab? Now() will only be calculated during a calcuation.
:)

Also, look into Progress Lines. A progress line set to the current date
will visually show you tasks that are behind schedule. :)

--
___
Brian K
Project MVP
http://www.projectified.com

Project Server Consultant
http://www.quantumpm.com
 
Top