S
Senbag
I am trying the following scenario in Enterprise custom fields.
I have two custom date fields "_210_Inception Phase Start" and
"_241_Transition Phase Finish" in project level. these dates will be entered
by the user during the proposal. I am trying to create a third number custom
field "NoOF Days" with following formula to calculate and populate the number
of days between the above two date fields.
this the formula I used:
IIf([_210_Inception Phase Start]<>"NA" Or [_210_Inception Phase Start]<>""
Or [_241_Transition Phase Finish]<>"NA" Or [_241_Transition Phase
Finish]<>"",0,(ProjDateDiff([_210_Inception Phase Start],[_241_Transition
Phase Finish])))
Since the dates fields are empty or NA at the beginning, I have used the
above formula.
After saving this above field, I tried to create a proposal. the new field
"NoOF Days" is not showing up in the PWA but it shows up in Project pro
Project Information.
If I take the formula out of this field, it shows up in the PWA when i
create new proposal.
What I am doing wrong?
Anyhelp on this appreciated.
Thanks
Senbag
I have two custom date fields "_210_Inception Phase Start" and
"_241_Transition Phase Finish" in project level. these dates will be entered
by the user during the proposal. I am trying to create a third number custom
field "NoOF Days" with following formula to calculate and populate the number
of days between the above two date fields.
this the formula I used:
IIf([_210_Inception Phase Start]<>"NA" Or [_210_Inception Phase Start]<>""
Or [_241_Transition Phase Finish]<>"NA" Or [_241_Transition Phase
Finish]<>"",0,(ProjDateDiff([_210_Inception Phase Start],[_241_Transition
Phase Finish])))
Since the dates fields are empty or NA at the beginning, I have used the
above formula.
After saving this above field, I tried to create a proposal. the new field
"NoOF Days" is not showing up in the PWA but it shows up in Project pro
Project Information.
If I take the formula out of this field, it shows up in the PWA when i
create new proposal.
What I am doing wrong?
Anyhelp on this appreciated.
Thanks
Senbag