Hi Brains Trust. I'm trying to build a definition query (SQL) that looks a little like this;
fih_fire_type IN ('WF') And fih_year1 >= (YEAR(CURRENT_DATE())-20)
where fih_year1 is a short integer with a year in it (i.e. 2019, 2020, etc). I want to be able to filter my data by features that have a Year value within the last 20 years.
I believe the CURRENT_DATE function works, but it looks like YEAR() isn't available in the definition query SQL window, meaning I can't extract the current Year as an integer. I've tried a few others and keep having the same problem (limited SQL commands available).
Any tips on how to make this formula work?
