With ArcMap how to select records created this year 2014

[JoseSanchez]

Hi all,

How can I select all the records created in year 2014 in ArcMap when the layer is stored in SDE Oracle.

I am using Query Builder in ArcMap.

The field is a date field called DateCreated.

Thanks

I

[JoseSanchez]

A way to do that:

[datefield] >= TO_DATE('2014-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS')

Thanks