I have an ArcSDE feature class that contains a date field called "SALE_DATE". This sale date represents the bid date for ALberta crown mineral rights sales. A sale occurs about twice per month (one date value approx every two weeks). Eg. for January there would be values of 1/14/2015 and 1/28/2015. There are only ever 4 sales dates release at a time (4 date values in the feature class) and they revolve as the current sale occurrs, another one is released. I need to create 4 layers from this one feature class, each representing the next sale date. The trick is I want to set them up with SQL def query syntax so that the dates automatically revolve and I dont have to manually adjust the sale date, it should just grab the next available date value that is available.
This is an example of the syntax I have for the first upcoming sale date:
PROVINCE = 'AB' AND SALE_DATE > SYSDATE AND TO_CHAR (SALE_DATE, 'MM') = TO_CHAR (SYSDATE, 'MM') AND TO_CHAR (SALE_DATE, 'DD') < (TO_CHAR (SYSDATE, 'DD') + 2)