Database
[{"_id":{"$oid":"62f172b99d3a18179cee4c4c"},"Name":"pc","Score":46,"DateTime":{"$date":{"$numberLong":"1659646800000"}}},{"_id":{"$oid":"62f172b99d3a18179cee4c4d"},"Name":"p2","Score":47,"DateTime":{"$date":{"$numberLong":"1659646900000"}}}]
Query
db.collection.aggregate([{"$setWindowFields":{"partitionBy":null,"sortBy":{"DateTime":1},"output":{"minRank":{$rank:{}}}}},{"$setWindowFields":{"partitionBy":null,"sortBy":{"DateTime":-1},"output":{"maxRank":{$rank:{}}}}},{"$match":{$expr:{$or:[{$eq:["$minRank",1]},{$eq:["$maxRank",1]}]}}},{/** cosmetics*/"$unset":["minRank","maxRank"]}])