Database
[{"_id":"xxxxxxxxxxxxxxx","a":{"b":{"c":[{"date":ISODate("2021-01-01T09:02:53.217Z"),"value":"aaa"},{"date":ISODate("2022-01-01T09:03:38.948Z"),"value":"bbb"},{"date":ISODate("2023-01-01T09:15:03.376Z"),"value":"ccc"}]}},},{"_id":"yyyyyyyyyyyyyyy","a":{"b":{"c":[{"date":ISODate("2021-01-01T09:02:53.217Z"),"value":"aaa"},{"date":ISODate("2023-01-01T09:03:38.948Z"),"value":"bbb"},{"date":ISODate("2023-01-01T09:15:03.376Z"),"value":"ccc"}]}},}]
Query
db.collection.update({"a.b.c.date":{$lt:ISODate("2022-11-19")}},{$set:{"a.b.c.$[c].date":ISODate("2023-01-19T01:07:42.313+00:00")}},{arrayFilters:[{"c.date":{$lt:ISODate("2022-11-19")}}],multi:true})