Milestones' date on Project Center view

[Yves]

Hi,
I have created views in Project Center with fields and customized fields,
and my users required me to add dates coming from milestones in the project
schedules. For example, they want to display on a project center view the
contract signature date or the works start date (2 milestones).
How is possible to do that? Exept start and finish dates, we cannot select
other dates in the liste of available field.
Is there another way to do that? Is it possible to put a kind off "tag" on
the milestone to make them appear in the list of available field?

 

[Gordon]

Hi Yves,
I am guessing you are using PS 2007.

You could use the option of creating two Custom Enterprise Project Fields
(Date Type) called Contract Signature date and Works Start Date.
Omce these fields are created they will be available to be defined in
Project Center Views.

 

[Mike Mahoney]

Hi,
I have created views in Project Center with fields and customized fields,
and my users required me to add dates coming from milestones in the project
schedules. For example, they want to display on a project center view the
contract signature date or the works start date (2 milestones).
How is possible to do that? Exept start and finish dates, we cannot select
other dates in the liste of available field.
Is there another way to do that? Is it possible to put a kind off "tag" on
the milestone to make them appear in the list of available field?

Hi Yves

Define a task enterprise date field to capture date for selected
milestone. Use max function to roll this date up to summary level.
Define a project enterprise date field and set it equal to the task
enterprise date field.

regards

Mike

 

[Yves]

Hi Gordon,
Thanks for your response.
If I create customized fields, the date will not be updated with the project
schedule, I'll have to change the date in the project properties...
Actually, I want to keep the link with the project schedule...
And yes, I'm using PS 2007
Yves

 

[Yves]

Hi Mike,
Thank you for your time.
I don't see at the moment, what is a "task enterprise date field"... is it a
customized field created in PWA (or in ProjPro) ? If it is, is there a link
between the milestone's date and the field, or do I have to update this field
manually (in project properties)?
Actually, the solution could be to create a customized task field with a
formula to get the date coming from the task in the schedule... but I don't
know if it's possible...
Rgds

 

[Mike Mahoney]

Hi Mike,
Thank you for your time.
I don't see at the moment, what is a "task enterprise date field"... is it a
customized field created in PWA (or in ProjPro) ? If it is, is there a link
between the milestone's date and the field, or do I have to update this field
manually (in project properties)?
Actually, the solution could be to create a customized task field with a
formula to get the date coming from the task in the schedule... but I don't
know if it's possible...
Rgds







- Show quoted text -

Yves

In PWA create three enterprise custom fields:
1)At the task level: field 1, typically a text field with a pick list
identifying the milestone (M1 say)
2)At the task level: field 2, date field with formula e.g.iif([field1]
= "M1", [Finish],ProjDateValue("NA"))
set "calculation for task and group summary row" to Rollup, and
choose Maximum option.
3)At the project level: Field 3, date field with formula: [Field 2]

regards

Mike

 

[Gérard Ducouret]

Yves,

You will found here the full description of the excellent Mike's suggestion:
Look at the FAQ #17:
http://www.pragma-soft.com/index_fr.html
Hope this helps,

Gérard Ducouret