3 Replies Latest reply on Aug 13, 2015 12:04 PM by esancha

    Searching with GetPointsSQL for CreationDate or ChangeDate

    esancha

      HI!

       

      sorry in advance for my por english :-(

       

      I'm trying to perform a point search that meet the Creation Date is greater than or equal to today (for example) but I do not get it to work, I've tried to use as search criteria:

       

      CreationDate> = # 13/08/2015 # or CreationDate> = '13 / 08/2015 '

       

      but returns an error:

      -2147220355   "Call to retrieve points failed.  [-260] SQL: invalid WHERE clause"

       

      Any idea how to build the search criteria?

       

      Any other search made with string fields, tag like point source, exdesc, ..., works perfectly

       

      Thank you very much.

      Kind regards