ProjDiffDate behaves differently on Client than on Project Server

A

Al Himler

I wrote a formula to determine the number of business days between two dates.
It worked like a charm on the client side:

ProjDateDiff(datevalue([Current Date]),datevalue([Finish]),[Project
Calendar])/480

I then created an Enterprise Custom Field to do the same thing, pasted the
formula into it and saved it, but I got different behavior. When I viewed
the results on a Project View in PWA, the field with the same formula
displays 39138.88 for every task regardless of when the Finish date is set to.

Any thoughts on this?

Thanks,

Al
 
D

Dale Howard [MVP]

Al --

You might try opening a project, pressing the F9 function key to recalculate
it, and then save and publish the project. Let us know if this resolves the
issue with PWA.
 
A

Al Himler

I'll be darned...that did it...thanks Dale!

Al

Dale Howard said:
Al --

You might try opening a project, pressing the F9 function key to recalculate
it, and then save and publish the project. Let us know if this resolves the
issue with PWA.





Al Himler said:
I wrote a formula to determine the number of business days between two
dates.
It worked like a charm on the client side:

ProjDateDiff(datevalue([Current Date]),datevalue([Finish]),[Project
Calendar])/480

I then created an Enterprise Custom Field to do the same thing, pasted the
formula into it and saved it, but I got different behavior. When I viewed
the results on a Project View in PWA, the field with the same formula
displays 39138.88 for every task regardless of when the Finish date is set
to.

Any thoughts on this?

Thanks,

Al
Click to expand...
Click to expand...
 
D

Dale Howard [MVP]

Al --

This the behavior of Project Server 2003 after the Project Server
administrator creates a new enterprise field AFTER there are already
production projects in the database. The PM of each project must open the
project, press the F9 function key to recalcuate the project (and the new
formula), and then save and publish the project. Those steps are definitely
not intuitive, but keep them in mind for the future if you create any new
fields. Hope this helps.





Al Himler said:
I'll be darned...that did it...thanks Dale!

Al

Dale Howard said:
Al --

You might try opening a project, pressing the F9 function key to
recalculate
it, and then save and publish the project. Let us know if this resolves
the
issue with PWA.





Al Himler said:
I wrote a formula to determine the number of business days between two
dates.
It worked like a charm on the client side:

ProjDateDiff(datevalue([Current Date]),datevalue([Finish]),[Project
Calendar])/480

I then created an Enterprise Custom Field to do the same thing, pasted
the
formula into it and saved it, but I got different behavior. When I
viewed
the results on a Project View in PWA, the field with the same formula
displays 39138.88 for every task regardless of when the Finish date is
set
to.

Any thoughts on this?

Thanks,

Al
Click to expand...
Click to expand...
Click to expand...
 
A

Al Himler

Got it...I'll remember...thanks!

Al

Dale Howard said:
Al --

This the behavior of Project Server 2003 after the Project Server
administrator creates a new enterprise field AFTER there are already
production projects in the database. The PM of each project must open the
project, press the F9 function key to recalcuate the project (and the new
formula), and then save and publish the project. Those steps are definitely
not intuitive, but keep them in mind for the future if you create any new
fields. Hope this helps.





Al Himler said:
I'll be darned...that did it...thanks Dale!

Al

Dale Howard said:
Al --

You might try opening a project, pressing the F9 function key to
recalculate
it, and then save and publish the project. Let us know if this resolves
the
issue with PWA.





I wrote a formula to determine the number of business days between two
dates.
It worked like a charm on the client side:

ProjDateDiff(datevalue([Current Date]),datevalue([Finish]),[Project
Calendar])/480

I then created an Enterprise Custom Field to do the same thing, pasted
the
formula into it and saved it, but I got different behavior. When I
viewed
the results on a Project View in PWA, the field with the same formula
displays 39138.88 for every task regardless of when the Finish date is
set
to.

Any thoughts on this?

Thanks,

Al
Click to expand...
Click to expand...
Click to expand...
 
D

Dale Howard [MVP]

Al --

You are more than welcome for the help, my friend! :)





Al Himler said:
Got it...I'll remember...thanks!

Al

Dale Howard said:
Al --

This the behavior of Project Server 2003 after the Project Server
administrator creates a new enterprise field AFTER there are already
production projects in the database. The PM of each project must open
the
project, press the F9 function key to recalcuate the project (and the new
formula), and then save and publish the project. Those steps are
definitely
not intuitive, but keep them in mind for the future if you create any new
fields. Hope this helps.





Al Himler said:
I'll be darned...that did it...thanks Dale!

Al

:

Al --

You might try opening a project, pressing the F9 function key to
recalculate
it, and then save and publish the project. Let us know if this
resolves
the
issue with PWA.





I wrote a formula to determine the number of business days between
two
dates.
It worked like a charm on the client side:

ProjDateDiff(datevalue([Current Date]),datevalue([Finish]),[Project
Calendar])/480

I then created an Enterprise Custom Field to do the same thing,
pasted
the
formula into it and saved it, but I got different behavior. When I
viewed
the results on a Project View in PWA, the field with the same
formula
displays 39138.88 for every task regardless of when the Finish date
is
set
to.

Any thoughts on this?

Thanks,

Al
Click to expand...
Click to expand...
Click to expand...
 
Top