Using Date Queries in DR within a File Geodatabase (finding the last month)

JonahWaterman — Wed, 17 Jun 2015 18:38:16 GMT

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

Re: Using Date Queries in DR within a File Geodatabase (finding the last month)

MichelleJohnson — Fri, 19 Jun 2015 17:14:50 GMT

Jonah,

Try this: Date_Edited > CURRENT_DATE - 30

topic Re: Using Date Queries in DR within a File Geodatabase (finding the last month) in ArcGIS Data Reviewer Questions

Using Date Queries in DR within a File Geodatabase (finding the last month)

Re: Using Date Queries in DR within a File Geodatabase (finding the last month)