AnsweredAssumed Answered

Date Query within a File GDB for the last month

Question asked by jonah84 on Jun 18, 2015
Latest reply on Jun 18, 2015 by vangelo-esristaff

I am trying to set up a expression within a File GDB that selects all the new features created in the last month. I want to find all the new services/valves that where created in the last month. I have successfully found how to query the last month in a SDE environment but not within a File GDB. The syntax is different for a File GDB and I can't seem to find documentation to help.

I want to automate this selection through modelbuilder then export to a script and then run on windows scheduler. Thanks for your help.

 

 

So the logic is something like this (Which works in a SDE environment but not on a file GDB)

 

year( created_date)=year(CURRENT_TIMESTAMP) and month(created_date)=month(CURRENT_TIMESTAMP)-1

Outcomes