Database

[{"_id":"1","createdAt":"2019-02-20T21:34:17.634Z","updatedAt":"2022-03-01T20:47:55.100Z","fullName":"Jennifer Lieutard","firstName":"Jennifer","lastName":"Lieutard","conversations":[{"page":"1000","messages":[{"content":"lorem ipsum","date":ISODate("2019-09-23T10:40:59.394Z")},{"content":"lorem not ipsum","date":ISODate("2019-09-23T10:51:56.165Z")},]}]},{"_id":"2","createdAt":"2019-02-20T21:34:17.634Z","updatedAt":"2022-03-01T20:47:55.100Z","fullName":"Peter Pan","firstName":"Peter","lastName":"Pan","conversations":[{"page":"1001","lastMessage":"Yes they can","messages":[{"content":"lorem ipsum","date":"2019-09-23T10:40:59.394Z"},{"content":"lorem not ipsum","date":"2019-09-23T10:51:56.165Z"},]}]}]

Query

db.collection.aggregate([{$match:{"conversations":{$elemMatch:{"page":"1000",}}}},{$lookup:{from:"messages",let:{comment_date:ISODate("2019-12-13T13:56:06.225+00:00"),},pipeline:[{$match:{$expr:{$and:[{$eq:["$$comment_date","$messages.date.0"]}]}}}],as:"messages"}},{$group:{_id:0,res:{"$addToSet":"$fullName"}}}])

Result