Is there a way to select points from a range of dates to create a new layer? I want to clean up my data by making all points from previous years a separate layer but doing a selection by attributes and choosing each date individually is taking way too long.It would be perfect if there was a way to query out all points from 2013, for example.
You can use greater-than and less-than operators on dates, so something like this:
"CHANGE_DATE" > date '2012-12-31 00:00:00' AND "CHANGE_DATE" < date '2014-01-01 00:00:00'
Would work to grab all the dates for the year 2013. Note that the specific syntax of the query can change slightly depending on the data source. The above is for a file geodatabase.