Database
[{"promoted":{"promotedTill":ISODate("2020-11-13T16:14:38.139+00:00")}},{"promoted":{"promotedTill":ISODate("2021-11-13T16:14:38.139+00:00")}},{"promoted":{"promotedTill":ISODate("2022-11-13T16:14:38.139+00:00")}},{"promoted":{"promotedTill":ISODate("2023-11-13T16:14:38.139+00:00")}},{"promoted":{"promotedTill":ISODate("2024-11-13T16:14:38.139+00:00")}}]
Query
db.collection.find({"$and":[{"promoted.promotedTill":{"$gte":ISODate("2022-11-13T16:14:38.139+00:00")}},{"promoted.promotedTill":{"$lte":ISODate("2024-11-13T16:14:38.139+00:00")}}]})