SELECT vehiculo_id, max(created_at), estado
FROM partesdiarios
WHERE vehiculo_id = 1
GROUP BY date(created_at)