Getting current date using $date in Mongodb

Asked Aug 24 '20 at 16:10

Active Aug 24 '20 at 16:10

Viewed 377 times

db.collection.aggregate([
    {$addFields : {newDateField : {$toDate : {$multiply : ["$date", 1000]}}}},
    {$match : {newDateField: {$lte: new Date(), $gte: new Date(ISODate().getTime() - 1000 * 86400 * 30)}}}])

In the above query, I am trying to get all events that happened in the past 30 days (from now). In the shell, the query runs smoothly. However, I need to convert it to JSON extended. That means that I need to use $date keyword instead of new Date() as the documentation requires. If anyone knows how to do this, I would appreciate it.

asked Aug 24 '20 at 16:10

hot_zera

Were you able to figure this out? having the same issue now – Andrei S Nov 11 '22 at 14:32

Getting current date using $date in Mongodb

0 Answers0