Database
[{"items":[{"id":"1","audit":[{"validFrom":ISODate("2021-01-20T14:24:57.483Z"),"validTo":ISODate("2024-01-20T14:24:57.483Z")}]},{"id":"2","audit":[{"validFrom":ISODate("2021-01-19T14:24:57.483Z"),"validTo":ISODate("2024-01-21T14:24:57.483Z")}]}]}]
Query
db.collection.aggregate([{"$unwind":"$items"},{"$match":{"items.audit.validTo":{"$lte":ISODate("2024-01-20T14:24:57.483Z")}}},{"$project":{"audit":{"$filter":{"input":"$items.audit","as":"elem","cond":{"$lte":["$$elem.validTo",ISODate("2024-01-20T14:24:57.483Z")]}}},_id:0}}])