Create Replica with a date layerQuery condition

Question

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

StuartHarvey · Answer

That's what I tried initially. The date fields in the replica are returned as epoch timestamps, so it seemed like the local format to use, but nope had to convert it to the format above.

RandyBurton · Answer

Using an epoch timestamp in UTC may also work.

StuartHarvey · Answer

I also struggled with this for a while. The date format finally that worked for me was "YYYY-mm-dd" e.g "2018-07-20", please note that there is no 'date' prefix which was also tripping me up for a while.