Database
[{"_id":ObjectId("62bd901c4af4e9d2e1287984"),"ResponseItems":[{"_id":ObjectId("62bd9068b4598dd0bb07b536"),"Created":ISODate("2022-05-30T08:45:31.662Z"),"Options":["Some string 1","Some string 2"]},{"_id":ObjectId("62bd906e35087e146b6b28f6"),"Created":ISODate("2022-05-30T08:46:56.192Z"),"Options":["Some string 3","Some string 4"]}]},{"_id":ObjectId("5e29560a2c4c55d421a4e1b4"),"ResponseItems":[{"_id":ObjectId("62bd62ab886b3fde8368ec39"),"Created":ISODate("2022-06-30T08:45:31.662Z"),"Options":["Some string 1","Some string 2"]},{"_id":ObjectId("62bd6300886b3fde8368ec3f"),"Created":ISODate("2022-06-30T08:46:56.192Z"),"Options":["Some string 3","Some string 4"]},{"_id":ObjectId("62bd6349886b3fde8368ec46"),"Created":ISODate("2022-06-30T08:48:09.226Z"),"Options":null},{"_id":ObjectId("62bd64a88f5b6b24b6de199e"),"Created":ISODate("2022-06-30T08:54:00.450Z"),"Options":null},{"_id":ObjectId("62bd64aa8f5b6b24b6de19a7"),"Created":ISODate("2022-06-30T08:54:02.767Z"),"Options":null},{"_id":ObjectId("62bd64af8f5b6b24b6de19b1"),"Created":ISODate("2022-06-30T08:54:07.896Z"),"Options":null},{"_id":ObjectId("62bd64b38f5b6b24b6de19bc"),"Created":ISODate("2022-06-30T08:54:11.837Z"),"Options":null},{"_id":ObjectId("62bd64b78f5b6b24b6de19c8"),"Created":ISODate("2022-06-30T08:54:15.588Z"),"Options":["Some string 5","Some string 6"]},{"_id":ObjectId("62bd64bd8f5b6b24b6de19d5"),"Created":ISODate("2022-06-30T08:54:21.494Z"),"Options":["Some string 7"]},{"_id":ObjectId("62bd654d8f5b6b24b6de331d"),"Created":ISODate("2022-06-30T08:56:45.487Z"),"Options":null}]}]
Query
db.collection.aggregate([{"$match":{"_id":ObjectId("5e29560a2c4c55d421a4e1b4"),"ResponseItems":{"$elemMatch":{"Created":{"$gte":ISODate("2022-06-30T08:54:17Z"),"$lte":ISODate("2022-06-30T10:09:18.403Z")}}}}}])