[{id:"A",date:"1 jan 18",value:1},{id:"A",date:"2 jan 18",value:0},{id:"A",date:"3 jan 18",value:0},{id:"B",date:"14 jan 18",value:4},{id:"B",date:"15 jan 18",value:"5"},{id:"B",date:"16 jan 18",value:0},{id:"C",date:"16 jan 18",value:1},]

db.collection.aggregate([{"$addFields":{"date":{"$dateFromString":{"dateString":"$date"}}}},{"$sort":{"date":1}},{"$match":{"value":0}},{"$group":{"_id":"$id","date":{"$first":"$date"},"value":{"$first":"$value"}}}])