[{"_id":ObjectId("615c74d32f86c312a50da3d2"),"basic_column1":"post number 1","basic_column":"lorem ipsum","embededData":[{"date":ISODate("2021-11-05T00:00:00Z"),"embeded_column_1":23},{"date":ISODate("2022-11-06T00:00:00Z"),"embeded_column_1":24}]},{"_id":ObjectId("615c74d32f86c312a50da3d3"),"basic_column1":"post number 2","basic_column":"lorem ipsum","embededData":[{"date":ISODate("2021-11-05T00:00:00Z"),"embeded_column_1":25},{"date":ISODate("2021-11-06T00:00:00Z"),"embeded_column_1":26}]}]

db.collection.aggregate([{"$match":{"basic_column":{"$eq":"lorem ipsum"}}},{"$set":{"embededData":{"$filter":{"input":"$embededData","cond":{"$let":{"vars":{"date_year":{"$year":"$$this.date"}},"in":{"$and":[{"$gt":["$$date_year",2020]},{"$lt":["$$date_year",2022]}]}}}}}}}])