DEV Community

Cover image for How to query date range in Mongo
Adrian Matei for Codever

Posted on • Edited on • Originally published at codever.dev

7 1

How to query date range in Mongo

Use only the date1 part

In the following example only the date part is set. Time is set to by default to 00:00:00. So the following query compares all entries archived within a day (2021-06-14):

var start = new Date("2021-06-14");
var end = new Date("2021-06-15");

db.call_archive.find({
  archivedAt: {$gte: start, $lt: end}
}).pretty();

Enter fullscreen mode Exit fullscreen mode

Use both date and time

You can also specify the Time in ISO format

  • new Date("<YYYY-mm-ddTHH:MM:ss>") - specifies the datetime in the client's local timezone and returns the ISODate with the specified datetime in UTC
  • new Date("<YYYY-mm-ddTHH:MM:ssZ>") - specifies the datetime in UTC and returns the ISODate with the specified datetime in UTC
var start = new Date("2021-06-14");
var end = new Date("2021-06-15");

db.call_archive.find({
  archivedAt: {$gte: start, $lt: end}
}).sort({archivedAt: -1}).pretty(); //sort descending

Enter fullscreen mode Exit fullscreen mode

Shared with ❤️ from Codever. 👉 Use the Copy to mine functionality to copy the snippet to your own personal collection and easy manage your code snippets.


  1. https://docs.mongodb.com/manual/reference/method/Date/ 

Speedy emails, satisfied customers

Postmark Image

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up

Top comments (0)

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay