Syntax to query DateTime fields?

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?

Best answer by chmaloof

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

AuthorAnswer

5-Regular Member

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

1-Visitor

Hi Chris,

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

Sign up