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

[Vit]

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]

Hi,

Try:

IIf(DateDiff("d",[Last Update],Date())>=14,"Update Required","Current")

--

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

 

[Matthew Hodgson]

Hello,

I think the issue is that the calculation will only be performed when the
plan is opened and republished (and hence you'll get a "Current" calculated)
This is because formulas are calculated by Project - not on the Server. So
you will never get this data to show through PWA in the manner you'd like.

Instead of this method perhaps use "last published" field and sort / filter
the PWA views to look for any plan not published in the last 14 days and
invoke a business rule to tell everyone they must update their plans at
least fortnightly (in your case).

Hope that helps. Best of luck.

Matthew

 

[Mike Glen]

Hi Vit,

Next time, please post on the server newsgroup. Please see FAQ Item: 24.
Project Newsgroups. FAQs, companion products and other useful Project
information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP