Database
[{UserID:"1",StartDate:"2021-04-15",EndDate:"2022-01-18"},{UserID:"1",StartDate:"2022-04-01",EndDate:"2022-04-30"}]
Query
db.collection.find({$expr:{$and:[{$eq:["$UserID","2"]},{$gte:[{$toDate:"$StartDate"},{$toDate:"2022-04-01"}]},{$lte:[{$toDate:"2022-04-01"},{$toDate:"$EndDate"}]}]}})