SELECT Hmilogdf.MODULO, Hmilogdf.PROGLO,;
{fn substring(usualo,1,9)} AS cliente,;
{fn substring(usualo,10,12)} AS usuario, Hmilogdf.FECHLO,;
eval("{^" +transform(Hmilogdf.FECHLO, "@R 9999/99/99")+ "}") as fecha_conexion,;
Hmilogdf.HORALO, Hmilogdf.TILOLO, Hmilogdf.NRSELO, Hmilogdf.VRENT1,;
Hmilogdf.VRENT2, Hmilogdf.VRENT3, Hmilogdf.VRENT4, Hmilogdf.VRENT5,;
Hmilogdf.VRENT6, Hmilogdf.VRENT7, Hmilogdf.VRENT8, Hmilogdf.VRENT9,;
Hmilogdf.VRENTA, Hmilogdf.VRENTB, Hmilogdf.VRENTC, Hmilogdf.VRENTD,;
Hmilogdf.VRENTE, Hmilogdf.FECHAD;
FROM CGIPYT.HMILOGDF Hmilogdf;
WHERE Hmilogdf.TILOLO = 'CNT';
AND Hmilogdf.FECHLO BETWEEN ?desde AND ?hasta