last updated/last changed property associated with a task

[adamfnewton]

Hello,

On a task-basis rather a file-basis, is it possible to query for a last
updated/last changed property to find out how "stale" info for a given
task is? For example, a .mpp may have been saved yesterday, but nothing
has changed for tasks 4 and 52 for over two weeks. It'd be nice to
isolate those tasks that are stale.

 

[JackD]

Sometimes no change is a good thing. I'd just look at tasks that should be
started or should be starting soon and if they have no progress reported
against them then you have a problem. The only time I'd update a task in the
future is if I had better information about how long it is going to take or
who is going to do it. In the absense of new information, there is no reason
to change it.

 

[Ed Morrison]

Project does not store a created or modified timestamp at the task level.
You could create one by using the application event ProjectBeforeTaskChange
and modifying task level custom date fields.

If you were using Project Server, you could use a trigger on the msp_tasks
table.