I am stumped as to how to get this to work in ArcMap...
I have records being created ever day, and would like to be able to show records on a map that have been created within the last 2 days based on a date field in our SDE feature class. How can I write a definition query in SQL to do this so that it automatically changes to the current date and then grabs records from the past 2 days? I've looked on the web, but have had no luck finding anything that matches what I need.
The values in our SQL 2012 database for the created_date field are formatted as such:
2014-11-04 18:44:09.0000000