How do you reference "current date" in a Metabase MongoDB native query?

Question

I would like to use manual logic inside of a Metabase question. When referencing "Past 30 days" for example, the Metabase query builder can dynamically update the question to reference the current date. When converted to a native query, however, the dates convert to hard-coded dates eg. 2017-11-30. I've seen answers elsewhere suggesting "new Date()" etc but none of these will work within Metabase's native query editor. I'm looking for something like..

...
{
  "created_at": {"$gte": "new Date()"}
},
...

though this method does not work. Thanks in advance!

@aeto Any updates ? I am also stuck with the same issue. Found something but could not exactly find a solution. https://github.com/metabase/metabase/issues/4964 — Vivek Aditya, Dec 20 '17 at 07:08

score 1 · Answer 1 · answered Feb 17 '22 at 23:28

1

Using `new Date()`

As of v0.41, it seems like Metabase would accept the new Date() syntax and insert the server's date when writing it like so:

[{
    $group: {
        _id: new Date()
    }
}]

Proof of work on Metabase v0.41

answered Feb 17 '22 at 23:28

Zachary Dahan

1,419
16
26

score -3 · Answer 2 · answered Dec 01 '17 at 04:27

-3

Take "new Date()" out of quotes, you're sending in a string.

{
  "created_at": {"$gte": new Date()}
}

answered Dec 01 '17 at 04:27

Nick

352
1
7

3

Understood, though unfortunately in the Metabase native query world this does not work – tonyyin Dec 01 '17 at 19:44

How do you reference "current date" in a Metabase MongoDB native query?

2 Answers2

Using new Date()

Using `new Date()`