Formula -error in date field

[Erkki]

Hi.

I have customized a task date field with the following formula : IIF
([Name]="Some task name";[Start];"NA")
Calculation for task and group summary rows is set to : Rollup - Maximum.

Secondly I have a project date field to which I copy the contents in order
to show the critical task date -field at project level in Web Access -views.

This produces an ERROR in the custom date field. Any ideas ?

PS This is my second post and after that we have installed all service packs
(finnish also).


Thank You !

Erkki

 

[JackD]

"NA" is not a date. That is why you are getting an error. Try using a text
field for your calculation instead. Or if you have to use a date field you
can do this:

IIF([Name]="Some task name";[Start];ProjDateValue("NA")