Please help with "Last published" related formula/view!

[still-new]

Hello all,

I am new to the Project Server 2007 environment and would appreciate
your help on this -

When creating an Enterprise custom field on Project entity from PWA,
what fields can be used in the formula section? I thought I would be
able to use [Last Published], but I am getting an error that it is an
unrecognizable field. "Last Published" is available in the field list
while creating a custom view on the Project Center entity though.

What I want to do is to create an Enterprise field of type Flag which
is set to True if the project has been published more than 7 days ago.
I was thinking of something like the following -

IIf(Int(Date()-[Last Published])>7,True,False)

What am I missing?! If "Last Published" can't be used in the formula,
is there another approach?

I also tried creating a custom view since the "Last Published" field
is available there, but the filter would not let me specify [Today]-7
as the value. I suppose it takes only hard-coded values?

Thanks!

 

[Dale Howard [MVP]]

still-new --

You may be new, but you are asking intelligent helpful questions in this
forum. Congrats!

To give you the bad news, it appears that the Last Published field is not
available for use in a custom enterprise field. You can use the Last
Updated field, but not the Last Published field. Hope this helps.

 

[still-new]

Yes, this certainly helps since I won't waste my time trying to go on
this path! This is too bad though. The kind of view that I wanted
would have been easily done if only the "Last Published" was
available. Now looks like I am going to have to create a custom Web
part....