Database
[{"_id":ObjectId("5a934e000102030405000003"),"name":"foo","date":ISODate("2020-02-22")},{"_id":ObjectId("5a934e000102030405000004"),"name":"foo","date":ISODate("2020-02-23")},{"_id":ObjectId("5a934e000102030405000005"),"name":"bar","date":ISODate("2020-02-23")},{"_id":ObjectId("5a934e000102030405000000"),"name":"buz","date":ISODate("2020-02-21")}]
Query
db.collection.aggregate([{$sort:{name:1,date:1}},{$group:{_id:"$name",data:{$last:{date:"$date",_id:"$_id"}}}},{$project:{_id:"$data._id",date:"$data.date",name:"$_id"}}])