Database
[{name:"a","start_date":ISODate("2021-09-21T12:13:34.151+05:30"),"end_date":ISODate("2021-09-24T12:13:34.000+05:30"),},{name:"b","start_date":ISODate("2021-09-21T12:13:34.151+05:30"),"end_date":ISODate("2021-09-22T12:13:34.000+05:30"),},{name:"c","start_date":ISODate("2021-09-21T12:13:34.151+05:30"),"end_date":ISODate("2021-09-21T12:13:34.000+05:30"),}]
Query
db.collection.find({"$expr":{"$and":[{$lte:["$start_date",new Date()]},{$gte:["$end_date",new Date()]}]}})