Database
[{"someArray":[{"Date":ISODate("2021-09-30"),"value":"6.62"},{"Date":ISODate("2020-12-31"),"value":"8.67"},{"Date":ISODate("2019-12-31"),"value":"12.81"},{"Date":ISODate("2018-12-31"),"value":"13.82"},{"Date":ISODate("2017-12-31"),"value":"13.83"},]}]
Query
db.collection.aggregate([{"$project":{"someArray":{"$filter":{"input":"$someArray","as":"a","cond":{"$and":[{"$lte":["$$a.Date",ISODate("2020-12-31")]},{"$gte":["$$a.Date",ISODate("2017-12-31")]}]}}}}}])