Database

[{_id:1,"published_at":ISODate("2021-10-30")},{_id:2,"published_at":ISODate("2021-10-29")},{_id:3,"published_at":ISODate("2021-10-28")},{_id:4,"published_at":ISODate("2021-10-27")}]

Query

db.collection.aggregate([{"$setWindowFields":{"partitionBy":null,"sortBy":{"published_at":1},"output":{nearIds:{$addToSet:"$_id",window:{documents:[-1,1]}}}}},{"$match":{_id:2}},{"$lookup":{"from":"collection","localField":"nearIds","foreignField":"_id","as":"nearDocs"}},{"$unwind":"$nearDocs"},{"$replaceRoot":{"newRoot":"$nearDocs"}}])

Result