[{"event_type":"ENTRY","DateTime":ISODate("2024-02-08T00:00:00.000Z")},{"event_type":"ENTRY","DateTime":ISODate("2024-02-09T00:00:00.000Z")},{"event_type":"ENTRY","DateTime":ISODate("2024-02-10T00:00:00.000Z")},{"event_type":"DELETE","DateTime":ISODate("2024-02-10T00:00:00.000Z")},{"event_type":"DELETE","DateTime":ISODate("2024-02-24T00:00:00.000Z")}]

db.collection.aggregate([{$group:{_id:"$DateTime",entry:{$push:{$cond:[{$eq:["$event_type","ENTRY"]},"$$ROOT","$$REMOVE"]}},delete:{$push:{$cond:[{$eq:["$event_type","DELETE"]},"$_id","$$REMOVE"]}}}},{$match:{"delete.0":{$exists:true},"entry.0":{$exists:true}}},{"$replaceRoot":{"newRoot":{$first:"$entry"}}}])