Project - Column Set Up - automate date

I

Iris.Deas

Does anybody know how I can add a column to a project that
will automatically update wiht the 'last updated' date.
i.e. the last date any change made to that task?
 
J

John

Iris,
The answer is "Yes" but it isn't necessarily a simple process. By itself
the Project application has no way of knowing from one "save" to the
next which tasks, let alone which fields of those tasks, have been
changed. Therefore, to detect and date stamp tasks that have been
updated, some type of comparison needs to be performed between a
snapshot of the task's previous data and the tasks current data. The
simplest and most common comparison are to baseline data but baseline
data rarely represents the last data unless an interim baseline is set
each time the file is updated. Other schemes include using the add-in,
"Compare Project Files" available from the MS Project web site, or
writing a custom macro to perform a real time file compare and date
stamp those tasks that were updated.

If you only need to detect updates to a very limited number of fields,
this scheme might work although I haven't tried it. Set up spare fields
to temporarily store the current field values. Set up a formula to
compare the active field with the stored field. If a change is detected,
put the current date in a spare date field as a flag.

John
 
I

i.Deas

Many thanks for your detailed response. We will try and
set something up using your guidelines.

Thanks - Iris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top