Date comparison in mongodb

Question

I want to retrieve all the documents after a particular date. My database has date as - DateAdded:"2014-12-17 10:03:46.000Z"

I wrote the following query-

db.collection.find({DateAdded:{"$lte":new Date("2015-06-17 10:03:46.000Z")}}) 

But the results doesn't fetches any record even though there are records for the dates upto 2015-06-24.

Answer 1

You can use ISODate to compare dates:

"$lte" : ISODate("2015-06-17T10:03:46Z") 

ISODate works because that is the format your date is in.

new Date()  

wraps the date in an ISODate helper, but is not able to convert in your query.

Check out this link for more information: http://docs.mongodb.org/manual/core/shell-types/

Answer 2

Use ISODate

format:

{'field': {$operator: ISODate(yyyy-MM-ddThh:mm:ss.msZ)}} 

example:

db.getCollection('yourCollection').find({'sampleField': {$lte: ISODate('2015-06-17T10:03:46.000Z')}})