I was wondering if anyone knew how to build a definition query in Arcmap 10.0 that returns only features that are f.e. only 7 days old. I have a SDE geodatabase with polygons, each with a "date"-field (format yyy-mm-dd). I would like to select these features based on their age:
Output 1 ; Last 7 days
Output 2 ; Last 14 days
Output 3 ; Last 30 days
Output 4 ; Last year
....
Thanks in advance
Feature 3 ; Last 30 days