Syntax to query DateTime fields?

[chmaloof]

I'm trying to query a DateTime field in a DataTable.  A filter like

{ "filters": { "type": "GT", "fieldName": "endTime", "value": "2017-01-30 00:00:00" } }

does not seem to work.  What is the syntax to find all rows after a certain date?

[chmaloof · Accepted solution]

Figured it out.  It looks like the query value is a timestamp in milliseconds.

[jkaczynski]

Hi Chris,

Yes, from the back-end side the DateTime property is stored in the form of milliseconds. Not only for query purposes.