Custom Field Formula Help

C

Cole

I'm trying to build a formula in the Custom Field then Enterprise Project
Date selection. I want to calculate the difference between the Current date
and Status Date and keep getting ERROR. My formula is ([Status Date]-[Current
Date])/480, can someone please help???
 
C

Cole

Did the formula below but with custom Duration still get ERROR, any other
suggestions?

Dale Howard said:
Cole --

You should use a custom Duration field for this formula.

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


Cole said:
I'm trying to build a formula in the Custom Field then Enterprise Project
Date selection. I want to calculate the difference between the Current date
and Status Date and keep getting ERROR. My formula is ([Status Date]-[Current
Date])/480, can someone please help???
Click to expand...
Click to expand...
 
D

Dale Howard [MVP]

Cole --

Try this formula instead:

ProjDateDiff([Status Date],[Current Date])

Do know that the Status Date always carries the 5:00 PM time stamp and the
Current Date always carries the 8:00 AM time stamp, even if you cannot see
the time with the dates. Therefore is the Current Date is today and the
Status Date is yesterday, the formula will yield 0 days, when you would
expect 1 day. Because of how the dates carry the times with them and how
the formula calculates using this information, you may wish to add 1 day to
the result of the formula, as follows:

ProjDateDiff([Status Date],[Current Date]) + 480

Hope this helps.




Cole said:
Did the formula below but with custom Duration still get ERROR, any other
suggestions?

Dale Howard said:
Cole --

You should use a custom Duration field for this formula.

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


Cole said:
I'm trying to build a formula in the Custom Field then Enterprise
Project
Date selection. I want to calculate the difference between the Current date
and Status Date and keep getting ERROR. My formula is ([Status Date]-[Current
Date])/480, can someone please help???
Click to expand...
Click to expand...
Click to expand...
 
C

Cole

Dale,

Thanks for the information below!! It was a lifesaver. I am comfused as to
why the original formula, ProjDateDiff( date1, date2, calendar ), has
'calender' listed in the formula.

I'm Black Belt Certified with IIL. Do you know a place or a book where I can
learn more about Custom Field Formulas and etc.?

Cole
[email protected]

Dale Howard said:
Cole --

Try this formula instead:

ProjDateDiff([Status Date],[Current Date])

Do know that the Status Date always carries the 5:00 PM time stamp and the
Current Date always carries the 8:00 AM time stamp, even if you cannot see
the time with the dates. Therefore is the Current Date is today and the
Status Date is yesterday, the formula will yield 0 days, when you would
expect 1 day. Because of how the dates carry the times with them and how
the formula calculates using this information, you may wish to add 1 day to
the result of the formula, as follows:

ProjDateDiff([Status Date],[Current Date]) + 480

Hope this helps.




Cole said:
Did the formula below but with custom Duration still get ERROR, any other
suggestions?

Dale Howard said:
Cole --

You should use a custom Duration field for this formula.

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


I'm trying to build a formula in the Custom Field then Enterprise
Project
Date selection. I want to calculate the difference between the Current
date
and Status Date and keep getting ERROR. My formula is ([Status
Date]-[Current
Date])/480, can someone please help???
Click to expand...
Click to expand...
Click to expand...
 
D

Dale Howard [MVP]

Cole --

You are more than welcome, my friend! :)

The Calendar variable in the function allows you to specify which base
calendar is used for calculating the difference between dates. By default,
the function uses the Standard calendar and returns an answer in working
days. If you specified a 7-day base calendar, for example, then the
function would return an answer in calendar days.

We address the use of custom fields with formulas and graphical indicators
in our Project Server for Administrators book. Click the URL in my
signature block for more information about the books we publish. I'm not
certain our book would provide the depth you wish on writing formulas and
using functions in formulas. On the other hand, you would learn a heck of a
lot about Project Server by purchasing one or both of our Project Server
2003 books.

Perhaps someone else in the group can recommend a reference for writing
formulas with functions in custom fields. Hope this helps.




Cole said:
Dale,

Thanks for the information below!! It was a lifesaver. I am comfused as to
why the original formula, ProjDateDiff( date1, date2, calendar ), has
'calender' listed in the formula.

I'm Black Belt Certified with IIL. Do you know a place or a book where I
can
learn more about Custom Field Formulas and etc.?

Cole
[email protected]

Dale Howard said:
Cole --

Try this formula instead:

ProjDateDiff([Status Date],[Current Date])

Do know that the Status Date always carries the 5:00 PM time stamp and
the
Current Date always carries the 8:00 AM time stamp, even if you cannot
see
the time with the dates. Therefore is the Current Date is today and the
Status Date is yesterday, the formula will yield 0 days, when you would
expect 1 day. Because of how the dates carry the times with them and how
the formula calculates using this information, you may wish to add 1 day
to
the result of the formula, as follows:

ProjDateDiff([Status Date],[Current Date]) + 480

Hope this helps.




Cole said:
Did the formula below but with custom Duration still get ERROR, any
other
suggestions?

:

Cole --

You should use a custom Duration field for this formula.

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


I'm trying to build a formula in the Custom Field then Enterprise
Project
Date selection. I want to calculate the difference between the
Current
date
and Status Date and keep getting ERROR. My formula is ([Status
Date]-[Current
Date])/480, can someone please help???
Click to expand...
Click to expand...
Click to expand...
 
Top