Database
[{"Name":"Test","StartDatetime":ISODate("2024-05-15T15:00:41.180Z"),"EndDatetime":ISODate("2024-05-15T15:30:12.120Z")}]
Query
db.collection.aggregate([{"$match":{"$expr":{"$and":[{"$gte":[{"$dateToString":{"date":"$StartDatetime","format":"%H:%m:%S"}},"02:32:05"/** your start date input here*/]},{"$lt":[{"$dateToString":{"date":"$EndDatetime","format":"%H:%m:%S"}},"05:23:12"/** your end date input here*/]}]}}}])