Database

[{_id:"620df4541571891a71dfa372",user_id:"61cc109f967b757d484fbf3b",instrument_type:"binance",sub_instrument:"BTC/USDT",start_date:ISODate("2022-02-17T00:00:00.000+00:00"),type_quantity:2,prediction:"High",points:12,price:null,run_at:null,createdAt:ISODate("2022-02-17T07:08:04.633+00:00"),updatedAt:ISODate("2022-02-17T07:08:04.633+00:00")},{start_date:ISODate("2021-02-17T00:00:00.000+00:00"),type_quantity:2},{start_date:ISODate("2022-01-17T00:00:00.000+00:00"),type_quantity:2},{start_date:ISODate("2022-01-17T00:00:00.000+00:00"),type_quantity:10}]

Query

db.collection.aggregate([{"$match":{"$expr":{"$and":[{"$gte":["$$NOW","$start_date"]},{"$lte":["$$NOW",{"$dateAdd":{"startDate":"$start_date","unit":"week","amount":"$type_quantity"}}]}]}}}])

Result