Enterprise Formula

[Ryan]

Can anyone tell me how I can get the difference between,
an projectenterprisedate1 field and the
projectenterprisedate2 field to show the duration between
the two fields?
Thank you
Ryan

 

[Dale Howard]

Ryan --

Please try entering this formula in an enterprise project Duration field in
the Enterprise Global:

ProjDateDiff([Enterprise Project Date1],[Enterprise Project
Date2],"Standard")

As it is written above, the "Standard" reference indicates calculating the
Duration using the Standard calendar as the Project Calendar. If you use a
Project Calendar other than the Standard calendar, enter the name of your
calendar in quotes as shown above.

After you have written the formula, save and close the Enterprise Global,
and then close Microsoft Project 2002. Reopen Project to get the lastest
changes to the Enterprise Global.

Now open a project and click Project - Project Information... In the dialog
box, enter the dates for Enterprise Project Date1 and Enterprise Project
Date 2 and click OK. Now press the F9 key to get Project to recaluclate the
project. When you click Project - Project Information again, you should see
the Duration between the two dates.

Hope this helps.

--
Dale A. Howard
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"

 

[Ryan]

Hi Dale
I am still having no luck. The field is still 0 days. Do I
need to change a setting?
Thank you,
Ryan

-----Original Message-----
Ryan --

Please try entering this formula in an enterprise project Duration field in
the Enterprise Global:

ProjDateDiff([Enterprise Project Date1],[Enterprise Project
Date2],"Standard")

As it is written above, the "Standard" reference indicates calculating the
Duration using the Standard calendar as the Project Calendar. If you use a
Project Calendar other than the Standard calendar, enter the name of your
calendar in quotes as shown above.

After you have written the formula, save and close the Enterprise Global,
and then close Microsoft Project 2002. Reopen Project to get the lastest
changes to the Enterprise Global.

Now open a project and click Project - Project Information... In the dialog
box, enter the dates for Enterprise Project Date1 and Enterprise Project
Date 2 and click OK. Now press the F9 key to get Project to recaluclate the
project. When you click Project - Project Information again, you should see
the Duration between the two dates.

Hope this helps.

--
Dale A. Howard
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"

Can anyone tell me how I can get the difference between,
an projectenterprisedate1 field and the
projectenterprisedate2 field to show the duration between
the two fields?
Thank you
Ryan

.

 

[Dale Howard]

Ryan --

Did you enter the formulas exactly as I gave them to you? Did you confirm
that the custom fields used in the formulas are the exact custom fields you
are using to track those dates? Are you using a Project Calendar that is
different from the Standard calendar? Any of these could cause your
problem. You'll need to be more specific about your problem, and then
perhaps I can help you better. Let me know.

--
Dale A. Howard
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"

Hi Dale
I am still having no luck. The field is still 0 days. Do I
need to change a setting?
Thank you,
Ryan

-----Original Message-----
Ryan --

Please try entering this formula in an enterprise project Duration field in
the Enterprise Global:

ProjDateDiff([Enterprise Project Date1],[Enterprise Project
Date2],"Standard")

As it is written above, the "Standard" reference indicates calculating the
Duration using the Standard calendar as the Project Calendar. If you use a
Project Calendar other than the Standard calendar, enter the name of your
calendar in quotes as shown above.

After you have written the formula, save and close the Enterprise Global,
and then close Microsoft Project 2002. Reopen Project to get the lastest
changes to the Enterprise Global.

Now open a project and click Project - Project Information... In the dialog
box, enter the dates for Enterprise Project Date1 and Enterprise Project
Date 2 and click OK. Now press the F9 key to get Project to recaluclate the
project. When you click Project - Project Information again, you should see
the Duration between the two dates.

Hope this helps.

--
Dale A. Howard
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"

Can anyone tell me how I can get the difference between,
an projectenterprisedate1 field and the
projectenterprisedate2 field to show the duration between
the two fields?
Thank you
Ryan

.