[{"student":"a","package":[{"name":"one","createdAt":"2021-10-12T00:00:00","active":true},{"name":"two","createdAt":"2021-10-13T00:00:00","active":false},{"name":"three","createdAt":"2021-10-14T00:00:00","active":false}]},{"student":"b","package":[{"name":"one","createdAt":"2021-10-16T00:00:00","active":true},{"name":"two","createdAt":"2021-10-17T00:00:00","active":false},{"name":"three","createdAt":"2021-10-18T00:00:00","active":false}]},{"student":"c","package":[{"name":"one","createdAt":"2021-10-10T00:00:00","active":true},{"name":"two","createdAt":"2021-10-17T00:00:00","active":false},{"name":"three","createdAt":"2021-10-18T00:00:00","active":false}]}]

db.collection.aggregate([{"$set":{"sort-key":{"$reduce":{"input":"$package","initialValue":"0","in":{"$cond":[{"$and":["$$this.active",{"$gt":["$$this.createdAt","$$value"]}]},"$$this.createdAt","$$value"]}}}}},{"$sort":{"sort-key":1}},{"$unset":["sort-key"]}])