[{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},]

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