Empty Baseline Finish is NA

T

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")
 
T

TroyS

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


JackD said:
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

.
TroyS said:
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")
Click to expand...
Click to expand...
 
Top