jsn

How to select dates before and after 40 years from the current date

Discussion created by jsn on Sep 20, 2012
Hi,

This is the way to select  40 years ago  * 12 = 480 months:


  • add_months(sysdate, -480)  <=  [date field in feature class]   


  • add_months(sysdate, -480)  >=  [date field in feature class]  

Outcomes