Database
db={evacuees:[{"_id":ObjectId("5e9d5785e4c8343bb2b455cc"),"name":"Jenny Adams",date:ISODate("2022-02-23T06:10:05.832+00:00")},{"_id":ObjectId("5e9d5785e4c8343bb2b455db"),"name":"Mathew Smith","date":ISODate("2022-05-08T06:10:06.432+00:00")},{"_id":ObjectId("5e9d5785e4c8752bb2b455db"),"name":"Mika Art","date":ISODate("2018-05-08T06:10:06.432+00:00")}],evacuation:[{"_id":ObjectId("5e9d5745e4c8752bb2b455db"),name:"placeA",capacity:70,space:890,address:"fgfg"}]}
Query
db.evacuation.aggregate([{$lookup:{from:"evacuees",as:"evacuees",pipeline:[{$match:{$and:[{date:{$gte:ISODate("2020-05-08T06:10:06.432+00:00"),},},{date:{$lte:ISODate("2023-05-08T06:10:06.432+00:00")},},],},},],},},])