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"