MongoDB Query Dynamic Date Range?

Is anyone aware of a method to write a MongoDB query for a dynamic date-range? 

 

I found this link online, and tried the code below, but it does NOT work in the connector:

...
"order_date"
: {
$lt: new Date(),
$gte: new Date(new Date().setDate(new Date().getDate()-1))
}

 

Any thoughts on how we can do something like this in the connector?

Jacob Folsom
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

Comments

  • I know this question is very old, but I had a similar problem and solved it with an aggregation pipeline. Note, this requires MongoDB 4.2 or later.

    {$expr: {$gt: ["$order_date", {$subtract: ['$$NOW', 24*60*60*1000]}]}}

    This compute an "age" field that I can then filter on. I don't know if there's a simpler way but this worked for me.

    I also defined this pipeline in a MongoDB view and queried the view from Domo, using the simpler "Find" method. It's easier to manage complex pipelines outside of Domo. But whether you do that is your choice.