Distinct Query within date range.

[Joe Bohen]

I am having a problem with a database query I have asked a question in this area before but have not been able to get this working fully, the query I am using is:

https://api.appery.io/rest/1/db/colle...? where={"_updatedAt":{"$gte":{"$date":"2015-11-26T00:00:00Z"},"$lt":{"$date":"2015-11-27T00:00:00Z"}}}

The query provides a result but it does not apply the date filter! Where is the problem in this query?

[Alena Prykhodko]

Hello,

Where do you run this query? Please show us screen shot.

If you try directly in Database query it works as expected for me.