Hi Pepe,

I'm guessing id_fecha and id_fec_saldo_ini are date values? Looks like the date format gets bungled in the process, probably switching the day and month values. In my experience, directly feeding date variables into embedded sql is a gamble at best because it's hard to be sure that the format gets converted correctly.

Try converting the Powerbuilder date variables into a string and re-converting that string into a date using the to_date function of your database. Something like this:

string ls_fecha

string ls_fec_saldo_ini

ls_fecha = string(id_fecha, 'dd-mm-yyyy')
ls_fec_saldo_ini = string(id_fec_saldo_ini , 'dd-mm-yyyy')

select sum(importe) into :lc_importe_menos
from ftransf
where cenbanc = :is_cenbanc
and csubanc = :is_csubanc
and ncuenta = :is_ncuenta
and clvdeha = '1'
and foper <= to_date(:ls_fecha, 'dd-mm-yyyy')
and foper >=  to_date(:ls_fec_saldo_ini, 'dd-mm-yyyy')
using itr_sqlca;

Not sure if the to_date syntax is correct for informix but there should be something similar.