Formula Error Problem

S

Steve

I am trying to calculate the difference between actual
start and baseline start dates, but my actual start date
is NA until a date is entered. I created the following
formula to calculate the difference using the Current Date
insteade of Actual Date when the column revealed NA.
However, the formula below results in an error in my
calculated field. ..any suggestions as to what is wrong?

IIf([Actual Start]="NA",[Current Date]-[Baseline Start],
[Actual Start]-[Baseline Start])
 
J

Jack D.

Steve said:
I am trying to calculate the difference between actual
start and baseline start dates, but my actual start date
is NA until a date is entered. I created the following
formula to calculate the difference using the Current Date
insteade of Actual Date when the column revealed NA.
However, the formula below results in an error in my
calculated field. ..any suggestions as to what is wrong?

IIf([Actual Start]="NA",[Current Date]-[Baseline Start],
[Actual Start]-[Baseline Start])
Click to expand...

The problem is that the actual value that is stored is not "NA" it is really
(2^32) - 1
The workaround is described on my website here:

http://masamiki.com/project/customfieldFAQ.htm

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP
email: J -at- eM Vee Pee S dot COM


+++++++++++++++++++
 
Top