International problem : NA

[Robert]

Hello,
I want to create a calculated field with a IIF(condition) which displays
sometimes the NA value when used on an English version, and NC on a French
version.
But the function: ProjDateValue('NA') is quite xenophobic. Is there a way to
dispay NA on English version and NC on French version?
Thanks

 

[Jack Dahlgren MVP]

If you are testing the value of a field and doing something if the value is
"NA" then you can simply check the value.

If a field is NA then the value of that field = 2^32-1
So if you wanted to see if a particular task had a baseline you could just
write:

iif([Baseline Finish] > 500000, "field is NA", [Baseline Finish])

-Jack Dahlgren

 

[Robert]

Hi Jack,
My problem is excatly the contrary of that.
My formula is, in a type date custom field :
IIf(InStr([Name],"Revue d'outillage")>0 And
[Milestone]=True,[Start],ProjDateValue('NA'))
So the NA or the NC is the value I want to display on any version.

Robert

If you are testing the value of a field and doing something if the value
is "NA" then you can simply check the value.

If a field is NA then the value of that field = 2^32-1
So if you wanted to see if a particular task had a baseline you could just
write:

iif([Baseline Finish] > 500000, "field is NA", [Baseline Finish])

-Jack Dahlgren

Hello,
I want to create a calculated field with a IIF(condition) which displays
sometimes the NA value when used on an English version, and NC on a
French version.
But the function: ProjDateValue('NA') is quite xenophobic. Is there a way
to dispay NA on English version and NC on French version?
Thanks