Hi guys, I’ve the following query (find) in mongodb trying to search every record after a given date: { "customer.slug": "{{$json["slug"]}}", "status": {"$in": ["captured", "canceled"]}, "created_at": {"$gt": {"$date": "2021-08-01T00:00:00.000Z"}} } Results: if I remove the created_at statement,…

Query by timestamp in mongodb

RicardoE105 August 31, 2021, 11:12pm 2

Ah yes, that is sadly a limitation of the node. Dates are not handled correctly. In the post below, you can find the explanation.