Mongoose query by date

Question

I want to query mongoDB with document structure like this:

var ExampleSchema = mongoose.Schema({
    createdAt: { type: Date, default: Date.now },
    validUntil: Date,
    name: String
});

and need it to return only valid documents, i.e. where validUntil is greater than current time. This doesn't work, mongoose returns all documents:

var d = new Date();
var n = d.toISOString();
Example.find({ '$where': 'validUntil'>n })

Bertrand Martel · Accepted Answer · 2016-10-30 19:11:26Z

24

Use $gte like this :

Example.find({
    validUntil: {
        $gte: new Date(2016,09,30)
    }
})

edited Oct 30, 2016 at 19:11

answered Oct 30, 2016 at 19:04

Bertrand Martel

46k17 gold badges156 silver badges170 bronze badges

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

2 Comments

robere2 Over a year ago

@chovy Date.now() returns a number and not a Date object. If you want to compare with the current Date, then simply use new Date().

VitoCK Over a year ago

@robere2 when using new Date() it still throws me error for casting.

Tính Ngô Quang · Accepted Answer · 2018-12-05 02:34:14Z

12

If find in today, using momentjs

// start today
var start = moment().startOf('day');
// end today
var end = moment(today).endOf('day');

Example.find({ validUntil: { '$gte': start, '$lte': end })

answered Dec 5, 2018 at 2:34

Tính Ngô Quang

4,6721 gold badge38 silver badges35 bronze badges

Comments

Abderrahim Soubai-Elidrisi · Accepted Answer · 2018-11-09 10:38:25Z

3

get all created account today:

  let start = new Date(now.getFullYear(),now.getMonth(),now.getDate(),1,0,0);

  let end = new Date(now.getFullYear(),now.getMonth(),now.getDate()+1,0,59,59);

  let query = {createdAt: {$gte: start, $lt: end} };

  Account
  .find(query)
  .exec((err, accounts) => console.log(account) )

answered Nov 9, 2018 at 10:38

Abderrahim Soubai-Elidrisi

5,2621 gold badge31 silver badges41 bronze badges

Collectives™ on Stack Overflow

Mongoose query by date

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related