CODEWITHSUNDEEP
node.jsmongodbmongoose
HalfWebDev
HalfWebDev

Reputation: 7658

Can't get the documents by date Mongoose

I have saved documents by createdAt : new Date()

These get saved as for example say "createdAt" : ISODate("2017-01-02T06:46:15.619Z"),

Now when I fetch the results by a single date using the query below it won't find. 

User.find({
    "userStatus":"active",
    "entityType": {$ne: ""},
    "createdAt": {
        $gte: new Date(2017, 0, 2),//from date
        $lt: new Date(2017, 0, 2)//to date
    }},function(err,data){
        if(err){ ...

In my user model it goes like:

createdAt:Date

I am able to find for a broader range of dates but just not for a single date. I have tried $lte as well instead of $lt. All solutions on SO says the same thing. Where am I going wrong ?

Upvotes: 0

Views: 960

Answers (1)

Janvi Vakotar
Janvi Vakotar

Reputation: 151

db.User.find({ 
    createdAt:{
        $gte: ISODate("2016-11-16"),//from date
        $lte: ISODate("2016-12-01")}//To date
    }
);

Upvotes: 1

Related Questions