15 Replies Latest reply on Apr 28, 2015 2:08 PM by Melia Brush

    How do I use ArcFM Locator Attribute Query on a Date Field?  What Syntax?

    Dale Weathers

      How do I use ArcFM Locator Attribute Query on a Date Field?

       

      The Date_Modified: field offers a calendar for selecting a date; and then shows 7/1/2014 in the search field.  But it gives an error: “An error was returned from the search. Please ensure that the search criteria is valid.”

       

      I am using a connection to: “SQL Server Enterprise Geodatabase” with ArcFM 10.2.1.588, ArcGIS 10.2.1 with Windows 7.

       

      Searching ArcGIS and ArcFM help and support posts haven’t help me figure out the correct syntax.

       

      Even trying the ArcGIS Select-By-Attributes generated SQL: “...DateModified = date '2014-07-01 00:00:00'” returns the message: “The expression was verified successfully, but no records were returned.”

       

      (There are 83 records in the Attribute Table with 7/1/2014 in the Date Modified field.)

       

       

      Thanks for help us getting started in ArcGIS/ArcFM!