[{"_id":ObjectId("5ecd26504df3372a38afffd9"),"balance":104000,"bankID":"Bank-1","userEmail":"kumarshreyas073@gmail.com","bankName":"Corporation Bank","accountNumber":"03214569874563","ifsCode":"CORP0001236","branch":"Udupi","address":"Udupi","city":"Udupi","state":"Karnataka","openingBalance":100000,"transactions":[{"credit":2000,"debit":0,"_id":ObjectId("5ecd26614df3372a38afffea"),"transactionID":"CashTransaction-5ecd26614df3372a38afffe8","date":"30-05-2026","particulars":"By Cash-1","voucherType":"Cash"},{"credit":0,"debit":2000,"_id":ObjectId("5ecd272d4df3372a38b00012"),"transactionID":"Receipt-5ecd272d4df3372a38b00009","date":"29-07-2020","particulars":"To Suresh kumar","voucherType":"Receipt"},{"credit":0,"debit":2000,"_id":ObjectId("5ecd272d4df3372a38b00014"),"transactionID":"Receipt-5ecd272d4df3372a38b00003","date":"30-05-2024","particulars":"To Karthik","voucherType":"Receipt"}],"idCounter":1,"__v":0}]

db.collection.aggregate([{$match:{userEmail:"kumarshreyas073@gmail.com"}},{$addFields:{transactions:{$filter:{input:"$transactions",as:"transactions",cond:{$and:[{$gte:[{$dateFromString:{dateString:"$$transactions.date",format:"%d-%m-%Y"}},new Date("2020-07-20")],},{$lte:[{$dateFromString:{dateString:"$$transactions.date",format:"%d-%m-%Y"}},new Date("2020-07-31")],},],},},},},},])