How to tell if task is baselined within a formula

[M Colodzin]

Hi,

I'm trying to create a forumla to calculate the elapsed duration since the
start of a task.

I've created the following formula in an Enterprise Duration custom field
which is intended to produce a duration of "0" when tasks are not baselined.
It works correctly for tasks which have Basline Start, but produces an error
when tasks are not baselined (i.e. Baseline Start = "NA"):

IIf([Baseline Start]="NA",0,ProjDateDiff([Baseline Start],[Current Date]))

I've tried using the ProjectDateVaue calcuation as follows but still get the
same result:

IIf(ProjDateValue([Baseline Start])="NA",0,ProjDateDiff([Baseline
Start],[Current Date]))

Any ideas?

 

[Dale Howard [MVP]]

M --

Test for a Baseline this way:


IIf([Baseline Start]=ProjDateValue("NA"),0,ProjDateDiff([Baseline
Start],[Current Date]))

Hope this helps.

 

[M Colodzin]

Dale,

Thanks so much for the prompt response. That resolved my problem!

 

[Dale Howard [MVP]]

Michelle --

You are more than welcome, my friend!

Dale,

Thanks so much for the prompt response. That resolved my problem!
--
Michelle Colodzin, PMP

Hi,

I'm trying to create a forumla to calculate the elapsed duration since
the
start of a task.

I've created the following formula in an Enterprise Duration custom field
which is intended to produce a duration of "0" when tasks are not
baselined.
It works correctly for tasks which have Basline Start, but produces an
error
when tasks are not baselined (i.e. Baseline Start = "NA"):

IIf([Baseline Start]="NA",0,ProjDateDiff([Baseline Start],[Current
Date]))

I've tried using the ProjectDateVaue calcuation as follows but still get
the
same result:

IIf(ProjDateValue([Baseline Start])="NA",0,ProjDateDiff([Baseline
Start],[Current Date]))

Any ideas?