How to update the customized Project Enterprise number ?

[Dennis]

Hi all :

I want to get the day difference between system date and
PROJ_LAST_SAVED in the MSP_PROJECTS table and

then update the porject enterprise number with the day difference value.And
I would also like it to be effective in the

number and indicator in the PWA after the update was done.How can I do?


Thanks & Regards,

Dennis

 

[Dale Howard [MVP]]

Dennis --

You might try adding the following formula to a custom enterprise project
Duration field in the Enterprise Global file:

ProjDateDiff([Last Update],[Current Date],"Standard")

The date difference will be calculated based on the number of working days
shown on the Standard calendar. If you use a different default calendar for
your projects, then change the "Standard" value to the name of your
calendar. To see the calculation, open any project and then click Project -
Project Information.

If you want to show an indicator in PWA rather than a number, you will need
to set Graphical Indicators in the enterprise project Duration field you
selected for the calculation and then you will need to add the custom
enterprise project Duration field to the proper Project Center views. Hope
this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We wrote the books on Project Server"