Update 9.3.1 Help Documentation with Function to Query Geodatabase Archives Based on Current Date

Idea created by skeetidot on Apr 16, 2013
    New
    Score10
    • skeetidot
    Esri tech support provided a function that you can use to query a 9.3.1 archived SDE feature class to select the features which have been modified in the past day, week, month, etc.

    This query, for example, selects all changes in the past 7 days.
    GDB_FROM_DATE >= DATEADD(day, -7, GETDATE()) OR (GDB_TO_DATE >= DATEADD(day, -7, GETDATE())  AND GDB_TO_DATE <> '9999-12-31')

    It would be helpful to other 9.3.1 users to include this in the help documentation.

    This page would be a great place to include an example of this query:
    http://webhelp.esri.com/arcgisserver/9.3.1/dotNet/index.htm#geodatabases/workin-1866399760.htm

    As I understand, the comparable query in 10.1 is
    last_edited_date >= DATEADD(day, -7, GETDATE())