Unable to query data between two dates in MongoDB

Question

db.test.find({"date":{$gte:"2017-04-11",$lt:"2017-04-13"}},function(err,doc){
      console.log("date function called");
    res.json(doc);

    console.log(doc);
});

code works fine in mongodb and output,but in nodejs the output is empty array.

First, use console.log(err) to see if there is an error

krl
– krl

2017-04-01 11:00:26 +00:00
Commented Apr 1, 2017 at 11:00 — krl
– krl, Commented Apr 1, 2017 at 11:00
you should use date as object not as string

Alok Deshwal
– Alok Deshwal

2017-04-01 11:03:48 +00:00
Commented Apr 1, 2017 at 11:03 — Alok Deshwal
– Alok Deshwal, Commented Apr 1, 2017 at 11:03

krl · Accepted Answer · 2017-04-01 11:53:24Z

1

Collections can be queried with find. The result for the query is actually a cursor object. This can be used directly or converted to an array. Making queries with find()

cursor.toArray(function(err, docs){}) converts the cursor object into an array of all the matching records. Probably the most convenient way to retrieve results but be careful with large datasets as every record is loaded into memory. toArray

The mongo shell wraps objects of Date type with the ISODate helper; however, the objects remain of type Date. Return Date

var collection = db.collection('test');
collection.find({ "date": { $gte: new Date("2017-04-11"), $lt: new Date("2017-04-13") } })
  .toArray(function (err, doc) {
    console.log("date function called");
    if (err) {
      console.error(err);
    } else {
      console.log(doc);
      res.json(doc);
    }
  });

edited Apr 1, 2017 at 11:53

answered Apr 1, 2017 at 11:03

krl

5,3164 gold badges40 silver badges55 bronze badges

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

5 Comments

Vijaykumar Vijay Over a year ago

i used the above code but it gives ReferenceError: ISODate is not defined

Vijaykumar Vijay Over a year ago

i got a output like this : server running on port 9000 date function called []

krl Over a year ago

@VijaykumarVijay use new Date, not ISODate

krl Over a year ago

@VijaykumarVijay Is your collection named test?

Vijaykumar Vijay Over a year ago

i used new Date and collection name is test itself. It works fine in mongoshell but in nodejs i got like this ,date function called [] empty array

Collectives™ on Stack Overflow

Unable to query data between two dates in MongoDB

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related