Mongodb find created results by date today

by

Your start date object should hold the current date time hours at 00:00:00.000 (milliseconds precision) and set the hours for today’s date to 23:59:59.999:

var start = new Date();
start.setHours(0,0,0,0);

var end = new Date();
end.setHours(23,59,59,999);

Then pass the modified date objects as usual in your MongoDB query operator:

db.posts.find({created_on: {$gte: start, $lt: end}});

If you are using the dayjs date utility library, this can be done by using the startOf() and endOf() methods on dayjs current date object, passing the string 'day' as argument:

const start = dayjs().startOf('day'); // set to 12:00 am today
const end = dayjs().endOf('day'); // set to 23:59 pm today

You can also use $expr as follows:

db.posts.find({
    $expr: {
        $eq: [
            { $dateToString: { format: '%Y-%m-%d', date: '$$NOW' } },
            { $dateToString: { format: '%Y-%m-%d', date: '$created_on' } },
        ],
    },
})

More Related Contents:

  1. How to send documents from my mongodb database to android application?
  2. collection is not defined in mongodb
  3. Querying after populate in Mongoose
  4. How do I manage MongoDB connections in a Node.js web application?
  5. db.collection is not a function when using MongoClient v3.0
  6. Comparing mongoose _id and strings
  7. Why is it recommended not to close a MongoDB connection anywhere in Node.js code?
  8. How to use a variable as a field name in mongodb-native findOne()?
  9. Mongoose Unique values in nested array of objects
  10. MongoDB – Error: getMore command failed: Cursor not found
  11. Stream from a mongodb cursor to Express response in node.js
  12. MongoDB on with Docker “failed to connect to server [localhost:27017] on first connect “
  13. How to protect the password field in Mongoose/MongoDB so it won’t return in a query when I populate collections?
  14. How to get a callback on MongoDB collection.find()
  15. Fill missing dates in records
  16. Mongoose, find, return specific properties
  17. How to drop a database with Mongoose?
  18. How to use mongoose findOne
  19. Mongoose indexing in production code
  20. Meteor Subscribe doesn’t update sort order of collection
  21. Mongodb sort with case insensitive manner
  22. How do I get the objectID after I save an object in Mongoose?
  23. Mongoose password hashing
  24. Fail to connect Mongoose to Atlas
  25. What’s going on with Meteor and Fibers/bindEnvironment()?
  26. Which SchemaType in Mongoose is Best for Timestamp?
  27. Mongoose: ObjectId Comparisons fail inconsistently
  28. set field as empty for mongo object using mongoose
  29. Mongoose overwrite the document rather that `$set` fields
  30. Create unique autoincrement field with mongoose [duplicate]

Leave a Comment