Baseline Finish - test for null

[geoff.pratt]

I am in the Customise Fields formula box, testing for
blanks in Baseline Finish in an Iif statement.
I am trying to test for a null value or blanks in Baseline
Finish (or Baseline Start)in a Custom Formula.
I have tried testing for NA,"NA", na,"na", isnull
statements, isdate statements and others!!.
Can't get it to work.
Would appreciate your help.

Am using Proj 2002 Std.




Regards............Geoff

 

[Gérard Ducouret]

Hello Geoff,
Try something like this :
IIf([Baseline Finish]<>ProjDateValue(('NA'));"yes";"no")

 

[JackD]

For some odd reason Project stores a value of 2^32 - 1 (4294967295) in
fields which are blank or NA. Perhaps the value is actually -1 and it rolls
over? Anyway, regardless of why they do this the solution is simple, use an
iif statement and test for a large number.

Here is an example which you could use in a customized text field:

iif([baseline finish] > 500000, "no baseline", "whatever you want it to do
if it is not blank")

-Jack