Project Custom Field (2007): don't work!!!! (project Level)

[Vit @ OZ]

Hello,

I'm trying to customize a field on project level…

The field have to show if a project has been updated or not o the last 14
days…

I’m using Project Server 2003, Project Professional 2003 and PWA 2003.

Here you are the step that I have followed:

1) Opened Project Professional 2003
2) Opened Enterprise Global (Tool -> Enterprise Options -> Open
Enterprise Global)
3) Opened Enterprise Fields (Tool -> Customise -> Enterprise Fields…)
4) Selected “Projectâ€
5) Selected “Textâ€
6) Inserted the following formula: IIf(DateDiff("d",[Last Update],
[Current Date])>=14,"Update Required","Current")


The problem is that the Project Fields Seems not to be updated….

On the PWA view, for example, there is the following information:

Project Test
Last Modified: 30/04/2008
Last Published: 30/04/2008
Custom Field: Updated Required


But today is the 8th of May, so it have to be “Currentâ€!!!

I have check also on the Project Information (in Project Professional,
Project -> Project Information…), and unfortunately, the custom field value
is “Updated Requiredâ€â€¦

What’s wrong??

Where can I check “Last Modified Dateâ€, “Last Update Date†and “Last
Published Date†in Project Professional??

Thank you so much to every body will be able to help me…

Regards

Vit

 

[Rod Gill]

The problem is that PWA cannot recalculate your custom fields. To get around
this I create the report in Excel and use Excel to calculate based on saved
and published dates.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Vit @ OZ]

I can understand that on 2003 version it doesn't work...

I have tried to do the same on the 2007 version (MS Project Pro, PWA,
Project Server), where the custom field are inserted directly on the PWA...

neither on the 2007 version it works... why???

I just want to create a simply way to show to the executive (that generally
don't want to manipulate data from PWA and Excel), if their Project Manger
are doing a good work (for example they update regularly their projects...)

how can I do this in PWA??? (2003 and 2007 version....)


thank you so much to everybody.

Vit

The problem is that PWA cannot recalculate your custom fields. To get around
this I create the report in Excel and use Excel to calculate based on saved
and published dates.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hello,

I'm trying to customize a field on project level…

The field have to show if a project has been updated or not o the last 14
days…

I’m using Project Server 2003, Project Professional 2003 and PWA 2003.

Here you are the step that I have followed:

1) Opened Project Professional 2003
2) Opened Enterprise Global (Tool -> Enterprise Options -> Open
Enterprise Global)
3) Opened Enterprise Fields (Tool -> Customise -> Enterprise Fields…)
4) Selected “Projectâ€
5) Selected “Textâ€
6) Inserted the following formula: IIf(DateDiff("d",[Last Update],
[Current Date])>=14,"Update Required","Current")


The problem is that the Project Fields Seems not to be updated….

On the PWA view, for example, there is the following information:

Project Test
Last Modified: 30/04/2008
Last Published: 30/04/2008
Custom Field: Updated Required


But today is the 8th of May, so it have to be “Currentâ€!!!

I have check also on the Project Information (in Project Professional,
Project -> Project Information…), and unfortunately, the custom field
value
is “Updated Requiredâ€â€¦

What’s wrong??

Where can I check “Last Modified Dateâ€, “Last Update Date†and “Last
Published Date†in Project Professional??

Thank you so much to every body will be able to help me…

Regards

Vit