Empty Baseline Finish is NA

[TroyS]

I want to check a baseline date field.
If Baseline Finish is not there/empty/hasn't been set, then show "No
baseline" in a text field.
However, when there is no Baseline Finish date "NA" is displayed.

Yet if you check for either Baseline Finish = "NA" or if Baseline Finish
IsNull, formulas don't work. Though NA is being displayed, it seems to not
really be the value held by Baseline Finish.
What would you compare if Baseline Finish is empty/hasn't been set....?

Schedule Indicator:
Switch(Len(CStr([Baseline Finish]))<3,"No baseline",ProjDateDiff([Baseline
Finish],[Finish])/480>=5,"Late by more than 5 days",ProjDateDiff([Baseline
Finish],[Finish])/480>0,"Late",True,"On schedule")

 

[JackD]

You can find the answer for dealing with NA here:
http://masamiki.com/project/customfieldFAQ.htm

 

[TroyS]

Jack, thanks. I thought we would have to hard code the value in there, but
it just didn't seem 'right'....

You can find the answer for dealing with NA here:
http://masamiki.com/project/customfieldFAQ.htm



--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.

I want to check a baseline date field.
If Baseline Finish is not there/empty/hasn't been set, then show "No
baseline" in a text field.
However, when there is no Baseline Finish date "NA" is displayed.

Yet if you check for either Baseline Finish = "NA" or if Baseline Finish
IsNull, formulas don't work. Though NA is being displayed, it seems to
not
really be the value held by Baseline Finish.
What would you compare if Baseline Finish is empty/hasn't been set....?

Schedule Indicator:
Switch(Len(CStr([Baseline Finish]))<3,"No
baseline",ProjDateDiff([Baseline
Finish],[Finish])/480>=5,"Late by more than 5
days",ProjDateDiff([Baseline
Finish],[Finish])/480>0,"Late",True,"On schedule")

 

[Lars Hammarberg]

"NA" in date fields are represented as 2^32-1 = 4294967295