I have a date field with day month and year (dd/mm/yyyy), I want query out the records by year. How do I do this?
That depends on the underlying data. Is it a shapefile an FGDB, etc, etc.
If it is a Enterprise GDB SQL Server then this works:
DATEPART(year, MyDate) = 2005
It in a FGDB
Then it would be:
EXTRACT(YEAR FROM "MyDate") = 2005
Thanks so much Robert, I'll try that.
Here is some documentation on SQL for fGDB: SQL for reporting and analysis on file geodatabases—Help | ArcGIS Desktop
You may also want to look into the fGDB API: File GDB API 1.5 Release
Thanks George, I'll take a look at that.
Retrieving data ...