Database
db={expense:[{accountId:ObjectId("61f4f357624d000ad053d745"),currency:"1",expenseType:"1",amount:"20000",itemname:"salary",date:ISODate("2022-02-01")}],account:[{_id:ObjectId("61f4f357624d000ad053d745"),accountName:"BOI"}]}
Query
db.expense.aggregate([{$set:{amount:{"$toDecimal":"$amount"}}},{$match:{$and:[{currency:"1",expenseType:"1"},{date:{$gte:new Date("2022-02-01"),$lte:new Date("2022-02-10")},amount:{$gt:1,$lt:100000}}]}},{$lookup:{from:"accounts",localField:"accountId",foreignField:"_id",as:"account"}}])