Template
single collection
multiple collections
mgodatagen
update
indexe
explain
Stage
Database
bson
mgodatagen
[{"endDate":ISODate("2023-08-18T00:00:00Z")},{"endDate":ISODate("2023-08-01T00:00:00Z")}]
Query
db.collection.find({$expr:{$lt:[{$dateAdd:{startDate:"$endDate",unit:"day",amount:3}},"$$NOW"/** curTime*/]}})
Result