[{"active":true,"endDates":["16.11.2021","27.06.2020"],"startDates":["21.10.2022","16.10.2021","09.04.2020"]}]

db.collection.aggregate([{$project:{endDates:{$map:{input:"$endDates",in:{$dateFromString:{dateString:"$$this",format:"%d.%m.%Y"}}}},startDates:{$map:{input:"$startDates",in:{$dateFromString:{dateString:"$$this",format:"%d.%m.%Y"}}}}}},{$project:{dates:{$zip:{inputs:[{$reverseArray:"$startDates"},{$reverseArray:"$endDates"}],useLongestLength:true}}}},{$project:{res:{$toBool:{$size:{$filter:{input:"$dates",cond:{$and:[{$gte:[ISODate("2021-12-17T00:00:00Z"),{$first:"$$this"}]},{$or:[{$lt:[ISODate("2021-12-17T00:00:00Z"),{$last:"$$this"}]},{$eq:[{$last:"$$this"},null]}]}]}}}}}}}])