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.

Your date is in string format. You need to save/update it in IOSDate format to get result from current query. — Vishwas
– Vishwas, Commented Jun 26, 2015 at 11:28
It worked. Thanks. :) Can you please explain how and why did the earlier one didn't? — maggs
– maggs, Commented Jun 26, 2015 at 11:44
@L_7337 When you add a short explanation of the difference between Date and ISODate you could post this as an answer. — Philipp
– Philipp, Commented Jun 26, 2015 at 12:01

L_7337 · Accepted Answer · 2022-11-29 17:08:23Z

57

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.

answered Jun 26, 2015 at 12:22

2,74731 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Is there some reason that the Mongo shell allows queries with Date, since it doesn't seem to be useful in querying against Mongo date fields?

broken link, please update

Which library provides this ISODate function?

Prayag k · Accepted Answer · 2020-05-28 08:52:20Z

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')}})

Abdul Rahman A Samad · Accepted Answer · 2017-11-14 14:26:07Z

You can use this:

db.collection.find({DateAdded:{"$lte":new Date("2017-11-01")}})

It will convert your date format into this:

ISODate("2017-11-01T00:00:00Z")