Parse Error at char(670): Invalid type in operator >=. (Expression #1)

[rkeenan125]

Hi All,

I keep getting the error stated. The formula looks fine to me, I might need a second pair of eyes. Also if anyone knows of a formula to simplify this one, that would be great.

IIF([Age] < 0 , 'Not Yet Due',
IIF([Age] >= 0 AND [Age] <=30,'30',
IIF([Age] >=31 AND [Age] <=60,'60',
IIF([Age] >=61 AND [Age] <=90, '90',
IIF([Age] >=91 AND [Age] <=120, '120',
IIF([Age] >=121 AND [Age] <=150, '150',
IIF([Age] >=151 AND [Age] <=180, '180',
IIF([Age] >=181 AND [Age] <=210, '210',
IIF([Age] >=211 AND [Age] <=240, '240',
IIF([Age] >=241 AND [Age] <=270, '270',
IIF([Age] >=271 AND [Age] <=300, '300',
IIF([Age] >=301 AND [Age] <=330, '330',
IIF([Age] >=331 AND [Age] <=360, '360',
IIF([Age] >=361 AND [Age] <=390, '390',
IIF([Age] >=391 AND [Age] <=420, '410',
IIF([Age] >=421 AND [Age] <=450, '450',
IIF([Age] >=451 AND [Age] <=480, '480',
IIF([Age] >=481 AND [Age] <=510, '510', '510+'))))))))))))))))))

The error is referring to the highlighted operator in the last line.

Thank you for any help given

[usmanbashir · Accepted solution]

@rkeenan125 - I tried the formula, and it works for me. Can you confirm [Age] is a numerical data type? If it's a string, it will need to be updated to an integer or another numerical data type. 

[rkeenan125]

Just switched the input data type to a double. Works now! Thank you. Still a bit weird since it worked for me yesterday as a String.