I am trying to set up a expression within Data Reviewer that is running the check from a File GDB. 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.
I want to automate this 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
Solved! Go to Solution.
Jonah,
Try this: Date_Edited > CURRENT_DATE - 30