Node js mongoose querying by dates

Question

I'm trying to find out how to do an specific query with mongoose. I have in mongodb something like this:

 "startDateTime" : ISODate("2017-03-22T00:00:00.000Z"),
 "endDateTime" : ISODate("2017-03-27T00:00:00.000Z"),

I want to get all the documents which that specific date is within that "startDateTime" and "endDateTime". I have tried as follows but it returns no results.

     var criteria = {}; 
     criteria.$and = [];
     criteria.$and.push({ startDateTime: {$gte: queryDate} });
     criteria.$and.push({ endDateTime: {$lte: queryDate} });

your query seem correct. please check your queryDate value — vineet
– vineet, Commented Feb 17, 2017 at 5:17

parwatcodes · Accepted Answer · 2017-02-17 05:35:31Z

1

the queryDate is Same for both of the conditions if your queryDate = 17-02-2016 you are searching for the records greater then that timeperiod and as well as lesser then that time period.

which is returning [] null because their are no records of this timeperiod

 criteria.$and.push({ startDateTime: {$gte: '17-02-2016'} });
 criteria.$and.push({ endDateTime: {$lte: '17-02-2016'} });

 var criteria = {}; 
 criteria.$and = [];
 criteria.$and.push({ startDateTime: {$gte: queryDate} });
 criteria.$and.push({ endDateTime: {$lte: queryDate} });

edited Feb 17, 2017 at 5:35

answered Feb 17, 2017 at 5:18

parwatcodes

6,8045 gold badges29 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Node js mongoose querying by dates

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related