[QT_EFFECTIVE_DATE] - [HO_CONSTRUCTION_YEAR] AS AGE
But the data types are a bit different. For [QT_EFFECTIVE_DATE], the data looks like 20150124 and [HO_CONSTRUCTION_YEAR] is just the 4 digit year, like 2008. So I need to trim the right 4 digits of [QT_EFFECTIVE_DATE] to just extract the year so the math will work. What would the syntax look like? I tried the above but got an "invalid expression" error.
Will trimming it work? Or will I need to also convert the data types as well? If so, what does that syntax look like?