IF Statement not working

purplespirit

formula used to work but it doesn't anymore ... get the "Parse Error at char(0): Invalid Type in operator >.(Expression #1)

IF [Year Built] <= "1969" THEN "0000 - 1969"
ELSEIF
[Year Built]> "1969" && [Year Built] <= "1979" THEN "1970 - 1979"
elseif
[Year Built]> "1979" && [Year Built]<="1999" then "1980 - 1999"
elseif
[Year Built]>"1999" && [Year Built]<="2010" then "2000 - 2010"
elseif
[Year Built]>"2010" && [Year Built]<="2020" then "2011 - 2019"

ELSE ">=2020" ENDIF

Qiu

@purplespirit 

I am sorry, I had a typo earlier.

Your [Year Built] column should be String Type.

So two options,

1. Use select tool to change it to V_String

2. Remove the " in read part

IF [Year Built] <= "1969" THEN "0000 - 1969"
ELSEIF
[Year Built]> "1969" && [Year Built] <= "1979" THEN "1970 - 1979"
elseif
[Year Built]> "1979" && [Year Built]<="1999" then "1980 - 1999"
elseif
[Year Built]>"1999" && [Year Built]<="2010" then "2000 - 2010"
elseif
[Year Built]>"2010" && [Year Built]<="2020" then "2011 - 2019"

ELSE ">=2020" ENDIF

---

"