How can I remove older records from a collection in MongoDB?

Question

How can I remove older documents from a collection, older than seven days?

{ "orderID" : "456986", "orderType" : "OnlinePurchase", "orderStatus" : "expired", "address" : "Hexel", "payement" : "Card", "isDomestic" : true, "orderExpDate" : ISODate("2017-09-20T20:36:11.000Z"), "shipped" : false }

Answer 1

For removing documents before Date, your command should be:

db.collection.deleteMany( { orderExpDate : {"$lt" : new Date(YEAR, MONTH, DATE) } })

For removing records before 1 October 2017, the command will be:

db.collection.deleteMany( { orderExpDate : {"$lt" : new Date(2017, 9, 1) } })

October is the 10th month. If the month field is zero indexed, then we use 9, otherwise use 10.

...........................

This will remove all records older than seven days:

db.collection.deleteMany( { orderExpDate : {"$lt" : new Date(Date.now() - 7*24*60*60 * 1000) } })

Update: collection.remove is deprecated

Answer 2

db.collection.remove has been deprecated. You should use:
db.collection.deleteMany( { orderExpDate : {"$lt" : new Date(2017, 9, 1) } }))