Finding "NA"

[Shane]

In writing scripts and such to find "NA", I've been told to use the number
4294967295. For example: iif([date1]=4294967295,[date2],[date1]). This says
that if the contents of date1 is equal to NA, then place the contents of
date2 into date1. Otherwise, leave the contents of date1 as is. Does this
work or is there another way?
Shane

 

[JulieS]

Hi Shane,

Take a look at fellow MVP Jack Dahlgren's blog about Project. In the URL
listed below, he discusses the "NA" issue and using the ProjDateValue in
custom formulas.

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

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

 

[Shane]

Excellent help JulieS. That solved my problem.

Hi Shane,

Take a look at fellow MVP Jack Dahlgren's blog about Project. In the URL
listed below, he discusses the "NA" issue and using the ProjDateValue in
custom formulas.

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

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

In writing scripts and such to find "NA", I've been told to use the number
4294967295. For example: iif([date1]=4294967295,[date2],[date1]). This
says
that if the contents of date1 is equal to NA, then place the contents of
date2 into date1. Otherwise, leave the contents of date1 as is. Does this
work or is there another way?
Shane

 

[JulieS]

You're welome Shane and thanks for the feedback..

Julie

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

Excellent help JulieS. That solved my problem.

Hi Shane,

Take a look at fellow MVP Jack Dahlgren's blog about Project. In the URL
listed below, he discusses the "NA" issue and using the ProjDateValue in
custom formulas.

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

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

In writing scripts and such to find "NA", I've been told to use the
number
4294967295. For example: iif([date1]=4294967295,[date2],[date1]). This
says
that if the contents of date1 is equal to NA, then place the contents
of
date2 into date1. Otherwise, leave the contents of date1 as is. Does
this
work or is there another way?
Shane