Database
[{date:"01-06-2020",pid:1,pname:"Micheck"},{date:"03-06-2020",pid:2,pname:"Zohn"},{date:"07-06-2020",pid:3,pname:"Robert"},{date:"01-05-2020",pid:6,pname:"Josebh"}]
Query
db.collection.aggregate([{$addFields:{convertedDate:{$dateFromString:{dateString:"$date",format:"%d-%m-%Y",timezone:"UTC"}}}},{$match:{convertedDate:{$gte:ISODate("2020-06-01T00:00:00Z"),$lte:ISODate("2020-06-07T00:00:00Z")}}}])