Database
[{"Driver":1,"driver_vehicles":[{"name":"Car1","state":1,"vehicledates":[]},{"name":"Car2","vehicledates":[{"trip":ObjectId("6374c5521e0056579430e15e"),"trip_date":"Nov 28, 2022"},{"trip":ObjectId("6374c3c65c106e84520e2bda"),"trip_date":"Nov 30, 2022"},{"trip":ObjectId("63789e73aab4b1b08dac4d23"),"trip_date":"Dec 1, 2022"}],"state":1},{"name":"Car3","vehicledates":[{"trip_id":ObjectId("63776d5b9061c736099501ac"),"trip_date":"Dec 2, 2022"}],"state":1}],}]
Query
db.collection.find({"driver_vehicles":{$elemMatch:{"vehicledates":{$elemMatch:{"trip_date":{$nin:["Dec 1, 2022"]}}},"state":1}}})