AnsweredAssumed Answered

Searching with GetPointsSQL for CreationDate or ChangeDate

Question asked by esancha on Aug 13, 2015
Latest reply on Aug 13, 2015 by 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

Outcomes