Select to view content in your preferred language

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

3495
1
Jump to solution
06-17-2015 11:38 AM
JonahWaterman
Regular Contributor

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

0 Kudos
1 Solution

Accepted Solutions
MichelleJohnson
Esri Contributor

Jonah,

Try this:  Date_Edited > CURRENT_DATE - 30

View solution in original post

1 Reply
MichelleJohnson
Esri Contributor

Jonah,

Try this:  Date_Edited > CURRENT_DATE - 30