AnsweredAssumed Answered

Create Replica with a date layerQuery condition

Question asked by Jirwin_1 on Apr 9, 2018
Latest reply on Jul 22, 2018 by stuartharvey

I am building a replica using REST api to get at hosted features on ArcOnline.  At the moment I am not considering attachments and the output I am expecting is a SQLite geodatabase that will be downloaded

 

I am struggling on creating a layer query to take rows with a date greater than a certain date and I am getting an "invalid parameter" error.  Since the feature classes in the service are rather large, I need to filter them down prior to download.  For a check, I am able to substitute the date condition with say "objected<300" and everything runs fine. It appears my issue is the formatting of the date condition of which I can't find anywhere.

 

I've tried date'2018-04-04 12:05:45',  date'04/04/2018 12:05:45', date'04/04/2018 12:05:45PM' and others...

 

Any help would be appreciated.

 

 

 

The JSON return is

Outcomes