Find objects between two dates MongoDB

by

Querying for a Date Range (Specific Month or Day) in the MongoDB Cookbook has a very good explanation on the matter, but below is something I tried out myself and it seems to work.

items.save({
    name: "example",
    created_at: ISODate("2010-04-30T00:00:00.000Z")
})
items.find({
    created_at: {
        $gte: ISODate("2010-04-29T00:00:00.000Z"),
        $lt: ISODate("2010-05-01T00:00:00.000Z")
    }
})
=> { "_id" : ObjectId("4c0791e2b9ec877893f3363b"), "name" : "example", "created_at" : "Sun May 30 2010 00:00:00 GMT+0300 (EEST)" }

Based on my experiments you will need to serialize your dates into a format that MongoDB supports, because the following gave undesired search results.

items.save({
    name: "example",
    created_at: "Sun May 30 18.49:00 +0000 2010"
})
items.find({
    created_at: {
        $gte:"Mon May 30 18:47:00 +0000 2015",
        $lt: "Sun May 30 20:40:36 +0000 2010"
    }
})
=> { "_id" : ObjectId("4c079123b9ec877893f33638"), "name" : "example", "created_at" : "Sun May 30 18.49:00 +0000 2010" }

In the second example no results were expected, but there was still one gotten. This is because a basic string comparison is done.

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. How to query nested objects?
  4. MongoDB: Combine data from multiple collections into one..how?
  5. How to remove a field completely from a MongoDB document?
  6. Multiple join conditions using the $lookup operator
  7. how to convert string to numerical values in mongodb
  8. How to find MongoDB field name at arbitrary depth
  9. How to Model a “likes” voting system with MongoDB
  10. Overflow sort stage buffered data usage exceeds internal limit
  11. Mongo sort on a calculated condition
  12. MongoDB: Calculate dwell time between every status value change
  13. MongoDB: how to parse date in 3.6 mongoDb version?
  14. MongoDB – Querying between a time range of hours
  15. How to ignore nulls while unmarshalling a MongoDB document?
  16. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  17. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  18. Mongodb query specific month|year not date
  19. convert iso date to timestamp in mongo query
  20. Remove Duplicates from MongoDB
  21. Using $slice operator to get last element of array
  22. How to access overall document count during arithmetic aggregation expression
  23. Mongodb aggregation pipeline how to limit a group push
  24. Push to two separate arrays in one update call in mongodb
  25. How to toggle a boolean field in one document with atomic operation?
  26. Update embedded object inside array inside array in MongoDB
  27. How can I sort a Meteor collection by time of insertion?
  28. Mongodb concat int and string
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment