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