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

Hello,

I'm trying to customize a field on project level=85

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

I=92m 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=85)
4) Selected =93Project=94
5) Selected =93Text=94
6) Inserted the following formula: IIf(DateDiff("d",[Last Update],
[Current Date])>=3D14,"Update Required","Current")

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

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 =93Current=94!!!

I have check also on the Project Information (in Project Professional,
Project -> Project Information=85), and unfortunately, the custom field
value is =93Updated Required=94=85

What=92s wrong??

Where can I check =93Last Modified Date=94, =93Last Update Date=94 and =93La=
st
Published Date=94 in Project Professional??

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

Regards

Vit

Rod
Wed May 07 23:35:46 CDT 2008

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



"Vit" <FiNaR76@gmail.com> wrote in message
news:59360d98-b472-4e6b-937b-8d0d965b8537@l28g2000prd.googlegroups.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
Thu May 08 01:53:54 CDT 2008

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

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote in message
news:e9SUDUMsIHA.4492@TK2MSFTNGP02.phx.gbl...
> 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
>
>
>
> "Vit" <FiNaR76@gmail.com> wrote in message
> news:59360d98-b472-4e6b-937b-8d0d965b8537@l28g2000prd.googlegroups.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

Mike
Thu May 08 09:07:49 CDT 2008

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


Vit wrote:
> 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