query feature layer date field

GuyShaharabani — Thu, 04 Aug 2022 10:16:19 GMT

I'm trying to query a feature layer by a date field, and there is a problem with the 'less then' operator.

it is not a code problem, I'm trying to query in the feature layer rest.

this query works:

CreatedTime > TIMESTAMP '2022-01-01 15:30:00'

but this query does not:

CreatedTime < TIMESTAMP '2022-01-01 15:30:00'

this is the field:

and just to be clear.. there are rows that match both conditions.

I Don't know if this has anything to do with it but this is the SQL field:

I've tried to use between, sometimes it works and sometimes it doesn't(working example):

CreatedTime Between TIMESTAMP '2022-07-28 00:00:00' AND TIMESTAMP '2022-07-28 23:59:59'

an example of a query that have no results, that does have results in sql server:

CreatedTime Between TIMESTAMP '2021-07-01 11:00:00' AND TIMESTAMP '2022-07-06 11:00:00'

topic query feature layer date field in ArcGIS JavaScript Maps SDK Questions