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?

 

Thanks,Igor

Outcomes