[{"_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":ISODate("2026-05-30"),"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:{}},{$addFields:{transactions:{$filter:{input:"$transactions",as:"transactions",cond:{$and:[{$gte:["$$transactions.date",ISODate("2020-12-12")],},{$lte:["$$transactions.date",ISODate("2029-01-01")],},],},},},},},])