Database

[{_id:1,dDate:ISODate("2024-01-10T00:00:00Z")},{_id:2,dDate:ISODate("2024-01-11T00:00:00Z")},{_id:3,dDate:ISODate("2024-01-22T00:00:00Z")},{_id:4,dDate:ISODate("2024-01-23T00:00:00Z")},{_id:5,dDate:ISODate("2024-01-24T00:00:00Z")},{_id:6,dDate:ISODate("2024-01-30T00:00:00Z")},{_d:7,dDate:ISODate("2024-01-31T00:00:00Z")}]

Query

db.collection.aggregate([{"$setWindowFields":{"partitionBy":null,"sortBy":{"dDate":1},"output":{"prev":{"$first":"$dDate","window":{"documents":[-1,-1]}},"next":{"$first":"$dDate","window":{"documents":[1,1]}}}}},{$set:{include:{$gt:[{$size:{$filter:{input:["$dDate","$prev","$next"],cond:{$and:[{$gte:["$$this",ISODate("2024-01-22T00:00:00Z")]},{$lte:["$$this",ISODate("2024-01-24T00:00:00Z")]}]}}}},0]}}},{$match:{include:true}},{$unset:["include","next","prev"]}])

Result