SELECT ce.ben_id AS ID, b.ben_ape AS Apellido, b.ben_nom AS Nombre, b.doc_id AS Documento, tc.tcob_nombre, CONVERT(varchar, ce.cobesp_desde, 23) AS cobesp_desde, CONVERT(varchar, ce.cobesp_hasta, 23) AS cobesp_hasta FROM coberturaesp ce INNER JOIN tipocobertura tc ON ce.id_tipocob = tc.id_tipocob INNER JOIN benef b ON b.ben_id = ce.ben_id WHERE ce.id_tipocob = 8 AND CONVERT(date, ce.cobesp_hasta) BETWEEN CONVERT(date, '2026-01-01') AND CONVERT(date, '2026-01-31') ORDER BY ce.cobesp_hasta ASC