Formula referencing a "NA" date field

[VSAT Ryan]

I am trying to perform a calculation in a number field that references the
actual start field. I am currently using a "50/50" Earned Value method for a
task, which states that you get 50% credit for starting, and the 2nd 50% when
you finish it. I want the formula to go something like:

IIf([% Complete]=100,100,IIf([Actual Start]<>"NA",50,0)),0)

I have even tried using the CDate function for this calculation, but that
hasn't worked either. Has anyone tried doing this? Can anyone offer another
solution (while still using the number field).

Thanks!

 

[VSAT Ryan]

Nevermind, I think I got after searching for related topics (seems this has
come up often)...

IIf([% Complete]=100,100,IIf([Actual Start]<>ProjDateValue("NA"),50,0)),0)

 

[Steve House [Project MVP]]

Strange as it may seem, date fields that show "NA" do not contain a text
value. They actually contain a numeric value equal to 2^32 - 1.