I have a clause in Query Builder that goes like this:
CDTS like '2014%'
but this is hard coding the year and I would like to get the year dynamically from the current time and plug it in the Query Builder. I am trying:
CDTS LIKE EXTRACT(YEAR FROM CURRENT_DATE())% after looking at the ESRI reference page here: ArcGIS Help (10.2, 10.2.1, and 10.2.2)
but I still no luck...any ideas?