You can use an inner query on the openactivities .You can order by DESC for this and also filter by activity date > today()