Database
[{"_id":ObjectId("63de4823561e0319a5745537"),bookings:[{productBookingStartDate:ISODate("2023-04-03T05:18:31Z"),productBookingCompleteDate:ISODate("2023-04-21T05:18:31Z")}]},{"_id":ObjectId("63de4823561e0319a5745536"),bookings:[{productBookingStartDate:ISODate("2023-04-11T05:18:31Z"),productBookingCompleteDate:ISODate("2023-04-21T05:18:31Z")}]},{"_id":ObjectId("63de4823561e0319a5745535"),bookings:[{productBookingStartDate:ISODate("2023-04-03T05:18:31Z"),productBookingCompleteDate:ISODate("2023-04-07T05:18:31Z")}]}]
Query
db.collection.find({/** _id: ObjectId("63de4823561e0319a5745537"),*/bookings:{"$elemMatch":{productBookingCompleteDate:{"$gt":ISODate("2023-03-23T04:03:49Z")},productBookingStartDate:{"$lt":ISODate("2023-04-10T04:03:49Z")}}}})