how to force an end-date

[nigel tuffnel]

Hello everyone,

In our company (using EPM) we use specific task-texts for several
milestones (that are present in most of the projects). These milestones
are linked to each other most of the time. The last milestone occurs on
the last Thursday each month. Is it possible to use a formula that -
when it finds a certain string in the task-name - forces that task to
occur on the right date (maybe using a specific task-calendar)? If this
would be possible, a delay in for example the first milestone, would
result in the last milestone shifting to the next month
(automatically).

I hope I've described my problem well enough for you to figure out a
solution!

 

[Mike Glen]

Hi Nigel ,

Try posting on the server newsgroup as this one is closing down. 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

 

[marleixo]

You can make this in VBA or directly in the project server database..

In the database the user will see nothing, because the job will run at
server, but you will need to have very carefull with the project server
database, more time, more expensive...
In VBA I think that the best way is put your macro in the Project_Open
event,

in two ways you will have some problems, 'cause when user change some
date in the project your milestone will not change automatically...
only when the event or the job runs..