search

n8n-io / n8n

Free and source-available fair-code licensed workflow automation tool. Easily automate tasks across different services.
https://n8n.io
Other
48.82k stars 7.73k forks source link

MongoDB $date is not working #11751

Open asosahn opened 3 hours ago

asosahn commented 3 hours ago

Bug Description

I am trying to send a mongoDB query using { "$date" : "2024-11-08T00:00:00Z" }, but it is not working; if I put the query on Mongo compass, it works fine.

To Reproduce

Create a query like this

[{ "$match": { "created_at": { "$gte": { "$date": "2020-01-01T08:23:14.000Z" } } } }, { "$limit": 10 }]

Expected behavior

returning the expected data; the node does not return anything.

Operating System

n8n cloud

n8n Version

1.67.1

Node.js Version

NA

Database

SQLite (default)

Execution mode

main (default)

Joffcom commented 3 hours ago

Hey @asosahn,

We have created an internal ticket to look into this which we will be tracking as "GHC-447"