Test for Baseline Dates

[Stretch]

How do I test to see if a Baseline Start (or Finish) date exists?

I've tried testing for "NA" but was unsuccessful.

Thanks,

Stretch

 

[JulieS]

Hi Stretch,

Use the Project Date Value function. For example:

IIf([Baseline Finish]= ProjDateValue("NA"), "Has baseline", "No Baseline
Saved")

For additional information see fellow MVP Jack Dahlgren's blog page:
http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[Stretch]

Julie,

Thank ya, thank ya, thank ya.

I don't have much hair left to pull out.

Take care,

Stretch

Hi Stretch,

Use the Project Date Value function. For example:

IIf([Baseline Finish]= ProjDateValue("NA"), "Has baseline", "No Baseline
Saved")

For additional information see fellow MVP Jack Dahlgren's blog page:
http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

How do I test to see if a Baseline Start (or Finish) date exists?

I've tried testing for "NA" but was unsuccessful.

Thanks,

Stretch

 

[JulieS]

You're most welcome Stretch and thanks for the feedback. Glad to have
helped preserve a few more hair follicles

Julie

Julie,

Thank ya, thank ya, thank ya.

I don't have much hair left to pull out.

Take care,

Stretch

Hi Stretch,

Use the Project Date Value function. For example:

IIf([Baseline Finish]= ProjDateValue("NA"), "Has baseline", "No
Baseline
Saved")

For additional information see fellow MVP Jack Dahlgren's blog page:
http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

How do I test to see if a Baseline Start (or Finish) date exists?

I've tried testing for "NA" but was unsuccessful.

Thanks,

Stretch