03/03/2021 01:13:02 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->sigesp_apr_salctabco MÉTODO->uf_calcular_saldolibro ERROR-> Invalid query: ERROR: syntax error at or near "2020" LINE 19: AND fecmov<=''2020-12-31' ^ Whole query: SELECT codban, ctaban, sum(monhab) AS monhab, sum(mondeb) AS mondeb, (sum(mondeb)-sum(monhab)) AS saldo FROM ( SELECT codban, ctaban, COALESCE( SUM(monto - monret),0) As monhab, 0 AS mondeb FROM scb_movbco WHERE codemp='0001' AND (codope='RE' OR codope='ND' OR codope='CH') AND estmov<>'A' AND estmov<>'O' AND (estreglib<>'A' or (estreglib='A' AND estcon=1)) AND fecmov<=''2020-12-31' GROUP BY codban,ctaban UNION SELECT codban, ctaban, 0 AS monhab, COALESCE( SUM(monto - monret),0) As mondeb FROM scb_movbco WHERE codemp='0001' AND (codope='NC' OR codope='DP') AND estmov<>'A' AND estmov<>'O' AND (estreglib<>'A' or (estreglib='A' AND estcon=1)) AND fecmov<=''2020-12-31' GROUP BY codban,ctaban ) sbco GROUP BY codban,ctaban ORDER BY codban,ctaban