Find all documents within last n days

by

I just tested the following query against your data sample and it worked perfectly:

db.datecol.find(
{
    "date": 
    {
        $gte: new Date((new Date().getTime() - (15 * 24 * 60 * 60 * 1000)))
    }
}
).sort({ "date": -1 })

More Related Contents:

  1. Random record from MongoDB
  2. Find in Double Nested Array MongoDB
  3. MongoDB: upsert sub-document
  4. Add new field to every document in a MongoDB collection
  5. Check that Field Exists with MongoDB
  6. Find MongoDB records where array field is not empty
  7. How do I update Array Elements matching criteria in a MongoDB document?
  8. Get a count of total documents with MongoDB when using limit
  9. ‘Failed to unlink socket file” error in MongoDB 3.0
  10. To what level does MongoDB lock on writes? (or: what does it mean by “per connection”
  11. Mongo order by length of array
  12. Best practice to maintain a mgo session
  13. MongoDB group by array inner-elements
  14. Exception: can’t convert from BSON type EOO to Date
  15. Delete everything in a MongoDB database
  16. Mongodb Aggregation Framework: Does $group use index?
  17. mongodb.conf bind_ip = 127.0.0.1 does not work but 0.0.0.0 works
  18. How to use Elasticsearch with MongoDB?
  19. Meteor: difference between names for collections, variables, publications, and subscriptions?
  20. MongoDB – how to query for a nested item inside a collection?
  21. Get BinData UUID from Mongo as string
  22. Get n-th element of an array in MongoDB
  23. What’s the fastest way to copy a collection within the same database?
  24. Mongoose: deep population (populate a populated field)
  25. Getting a distinct aggregation of an array field across indexes
  26. How to get back the new value after an update in a embedded array?
  27. How to check if an array field contains a unique value or another array in MongoDB?
  28. MongoDB index/RAM relationship
  29. MongoDB Single Document size limit is 16MB
  30. mongodb aggregate query isn’t returning proper sum on using $sum

Leave a Comment