How to get Last modified date of MPP files

G

GP

Hi,
I want to filter out all the project which has been not modified by since a
date.how will I get the lost modified date of a Project ?
 
B

Ben Howard [MVP]

Out of the box this isn't available, but could easily be done with some VBA
and an Enterprise custom field.
 
J

Jack Dahlgren MVP

On project server you could include the last published field. Building a
filter on that might be a bit tricky. You would probably compare on current
date or something similar


-Jack Dahlgren
 
C

Chak

Hi GP,

You can do this on PWA. You have to modify the Project Center view.

Steps:

1) Server Settings -> Click on "Manage Views" under Look and Feel

2) Click on "Project Summary" view under Project Center

3) Select "Last Modified" field from Available Fields -> Click "Add"

4) Click on "Filter" button to define the filter

5) On Define Custom Filter window, choose “Last Modified" from Field
Name dropdown; choose "is greater than" from
Test dropdown; Type the condition on Value text box

Example: Last Modified is greater than 1/1/2009

6) Click "OK" to close the defined filter

7) View the Project Center view to see the results

Note: If you do not want to modify the Project Center view, you can
define the custom view using copy option; you can also find the Last
Published column in step 3.


Thanks
Chak
pVector Technologies
http://www.pvectortech.com
http://www.epmcentral.com
 
R

Robert

Hi Chak,

I followed your advice and I inserted the "Last Modified" field in a custom
Project Center view.
By the way, I inserted also the "Last Published" field. I'm interested of
tracking my PMs tracking....
I expected that "Last Modified" field was updated when the PM clicked
File>Save
I expected that "Last Published" field was updated when the PM clicked
File>Publish.
It would be interesting to compare the two dates but...
- When you publish a project, you are obliged to save it.
- If you want to "push" the save date to PWA, you have to publish the
project.
So these two fields display always the same date.
Is it possible to exit this vicious circle?
Thanks

"Chak" <[email protected]> a écrit dans le message de (e-mail address removed)...
Hi GP,

You can do this on PWA. You have to modify the Project Center view.

Steps:

1) Server Settings -> Click on "Manage Views" under Look and Feel

2) Click on "Project Summary" view under Project Center

3) Select "Last Modified" field from Available Fields -> Click "Add"

4) Click on "Filter" button to define the filter

5) On Define Custom Filter window, choose “Last Modified" from Field
Name dropdown; choose "is greater than" from
Test dropdown; Type the condition on Value text box

Example: Last Modified is greater than 1/1/2009

6) Click "OK" to close the defined filter

7) View the Project Center view to see the results

Note: If you do not want to modify the Project Center view, you can
define the custom view using copy option; you can also find the Last
Published column in step 3.


Thanks
Chak
pVector Technologies
http://www.pvectortech.com
http://www.epmcentral.com
 
A

Andrew Lavinsky

Nope. My recommendation however (depending on your update methodology) is
to display the Status Date. The difference between the Status Date and the
Published Date will tell you a lot about your schedule and your schedulers.

The Save Date is a bit arbitrary in my opinion.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
Hi Chak,

I followed your advice and I inserted the "Last Modified" field in a
custom
Project Center view.
By the way, I inserted also the "Last Published" field. I'm interested
of
tracking my PMs tracking....
I expected that "Last Modified" field was updated when the PM clicked
File>> Save
File>>
I expected that "Last Published" field was updated when the PM clicked
File>> Publish.
File>>
 
J

Jack Dahlgren MVP

I often advise that people be trained to set status date on a weekly basis
to confirm that their schedule is up to date. One can make that case that if
a status date is stale, then the person updating the schedule is either not
updating it, or is not competent in updating their schedule. Either of which
is cause to not trust the data.

-Jack Dahlgren
 
R

Robert

I agree with you Andrew: I already displayed the Status Date and I added a
red graphical indicator when this Status Date is too ancient.
 

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