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, Jun 26 '15 at 11:28
It worked. Thanks. :) Can you please explain how and why did the earlier one didn't? — maggs, Jun 26 '15 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, Jun 26 '15 at 12:01

L_7337 · Answer 1 · 2022-11-29T17:08:23.537

50

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.

edited Nov 29 '22 at 17:08

answered Jun 26 '15 at 12:22

L_7337

2

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? – trey-jones Oct 30 '19 at 14:47
broken link, please update – Ramesh Pareek Nov 14 '22 at 16:51

score 21 · Answer 2 · edited May 28 '20 at 08:52

21

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

edited May 28 '20 at 08:52

Prayag k

answered Feb 05 '18 at 04:09

Aljohn Yamaro

score 18 · Answer 3 · answered Nov 14 '17 at 14:26

18

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")

answered Nov 14 '17 at 14:26

3 Answers3