Database
db={"reservation":[{_id:1,startDate:"2025-04-19T08:24:36.000+00:00",endDate:"2026-02-07T00:31:40.000+00:00"},{_id:2,startDate:"2022-04-19T08:24:36.000+00:00",endDate:"2023-04-19T08:24:36.000+00:00"}],"meta":[{"by":"steevej-playground","at":"gmail.com","for":"https://www.mongodb.com/community/forums"}]}
Query
db.reservation.aggregate([{$match:{startDate:{$gte:"2025-04-18T13:30:00.000Z",$lte:"2026-04-20T14:30:00.000Z"},endDate:{$lte:"2026-04-20T14:30:00.000Z",$gte:"2025-04-18T13:30:00.000Z"}}}])