Getting a Parse Error

[smrithiraj]

Hi 

Is there a problem with the below formula? I get an error on the second line at [NOTACTIVE]='Y' where it says "Invalid type in operator =="

IF [NOTACTIVE]='N' AND IsNull([Due Date]) THEN 30
ELSEIF [NOTACTIVE]='Y' THEN [Due Date] ELSE '' ENDIF

Please help..

Thanks

Smrithi

[gawa · Accepted solution]

hi @smrithiraj This is typical error when field type is not as intended at somewhere. Can you check following points?

1) The field [NOTACTIVE] is STRING type. (Wasn't it Bool type? If so, you should rephrase it [NOTACTIVE]="False", for example.)

2) Confirm the correct field type is specified to the field you apply this formula expression. Default field type of new column created by Formula tool is "V_WString", otherwise you intentionally change it.

You write "THEN 30", so it should be numeric type(Byte, INT, Double..). On the other hand, you also write "THEN [Due Date]" that can be Date/DateTime type.