Elch2004
Industrial
- May 9, 2004
- 1
Tried this:
For an attribute I created this formula:
IIf([Anfang]>DateSerial(2004;5;10)AND[Anfang]<DateSerial(2004;6;2);"Ja;"Nein")
MS Project complained, this formula is not valid (I am using the German version).
I didnt type in the formula, I only used the buttons to create it. In the Help of MS Project there is no ";" in the IFF() Statement, instead they use only ",".
So I tried the AND with simple [text1] = "name" AND [text2] = "another name" and used only ",". That worked.
Then I tried again the DateSerial(y;m;d). There I had to use the ";" an then MS Project started again complaining.
Please: What's wrong?
Thank's
M. Raab
For an attribute I created this formula:
IIf([Anfang]>DateSerial(2004;5;10)AND[Anfang]<DateSerial(2004;6;2);"Ja;"Nein")
MS Project complained, this formula is not valid (I am using the German version).
I didnt type in the formula, I only used the buttons to create it. In the Help of MS Project there is no ";" in the IFF() Statement, instead they use only ",".
So I tried the AND with simple [text1] = "name" AND [text2] = "another name" and used only ",". That worked.
Then I tried again the DateSerial(y;m;d). There I had to use the ";" an then MS Project started again complaining.
Please: What's wrong?
Thank's
M. Raab
