AnsweredAssumed Answered

Query Builder clause issue in ArcMap

Question asked by igor92128 on Oct 28, 2014
Latest reply on Oct 29, 2014 by igor92128

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?