How to sort a collection by date in MongoDB?

Question

I am using MongoDB with Node.JS. I have a collection that contains date and other strings. Date is a JavaScript Date object.

How can I sort this collection by date?

Answer 1

Just a slight modification to @JohnnyHK's answer

 collection.find().sort({datefield: -1}, function(err, cursor){...}); 

In many cases, we want the latest entries to be returned (e.g. for the latest updates / inserts).

Answer 2

Sorting by date does not require anything special. Just select the desired collection date field.

Updated for the built-in driver 1.4.28 node.js, you can sort ascending on datefield any of the following methods:

 collection.find().sort({datefield: 1}).toArray(function(err, docs) {...}); collection.find().sort('datefield', 1).toArray(function(err, docs) {...}); collection.find().sort([['datefield', 1]]).toArray(function(err, docs) {...}); collection.find({}, {sort: {datefield: 1}}).toArray(function(err, docs) {...}); collection.find({}, {sort: [['datefield', 1]]}).toArray(function(err, docs) {...}); 

'asc' or 'ascending' can also be used instead of 1 .

To sort in descending order, use 'desc' , 'descending' or -1 instead of 1 .

Answer 3

Sushant Gupta's answers are a bit outdated and no longer work.

The following snippet should look like this:

collection.find({}, {"sort" : ['datefield', 'asc']} ).toArray(function(err,docs) {});

Answer 4

This worked for me:

 collection.find({}, {"sort" : [['datefield', 'asc']]}, function (err, docs) { ... }); 

Using Node.js, Express.js and Monk

Answer 5

 collection.find().sort('date':1).exec(function(err, doc) {}); 

it worked for me

indicated by https://docs.mongodb.org/getting-started/node/query/

Answer 6

Additional area [] A bracket is required for the sort parameter to work.

 collection.find({}, {"sort" : [['datefield', 'asc']]} ).toArray(function(err,docs) {}); 

Answer 7

From mongoose, it's simple:

 collection.find().sort('-date').exec(function(err, collectionItems) { // here your code }) 

Answer 8

 db.getCollection('').find({}).sort({_id:-1}) 

This sorts your collection in descending order depending on the insertion date.

Answer 9

if your date format is as follows: 02/14/1989 ----> you may find some problems

you need to use ISOdate as follows:

 var start_date = new Date(2012, 07, x, x, x); 

-----> Result ------> ISODate ("2012-07-14T08: 14: 00.201Z")

now just use the query as follows:

  collection.find( { query : query ,$orderby :{start_date : -1}} ,function (err, cursor) {...} 

what he:)