Unable to Fix IF Statement - Invalid Type in Operator

jjg21

I've been using the following statement:

IF [Days Outstanding]<31 THEN "0-30" ELSEIF [Days Outstanding]<61 THEN "31-60" ELSEIF [Days Outstanding]<91 THEN "61-90" ELSE "Over 90" ENDIF

Which keeps giving me an error at the "[Days Outstanding]<91" section saying that there is an invalid type in operator with the "<" underlined.

I cannot figure out what the error.

Appreciate the assistance.

Cheers

apathetichell

@Qiu-  if the datatype was wrong - shouldn't it throw off an error at the first compare? That the error apparently occurs at >91 makes me think that formula isn't exactly as transcribed above. Or perhaps the error is that it's a string set to 4 and "over 91" is too many characters so it's truncating.

I'm running it as a cut and paste directly in formula with a number going in and a string coming out and everything is fine.  I wouldn't write the formula that way - but it does work. So @jjg21  - try cutting and pasting it from what you posted here and see if fixes. Could be some stray character you're not seeing. @Qiu 's way of course works just as well. And personally, I'd do a switch command with some kind of floor division by 30.  But that's just personal preference.