NO MATCH DATE IN REPORTS
now i am calling the report with form application ... i add some parameters :
WHERE_CLAUSE := 'where MIN_COMPA= :compa and BOL_COMPA = MIN_COMPA and MIN_SUCURSAL = :sucu and BOL_REFERENCIA = MIN_NUMREFERENCIA and MIN_TIPOMOVIM IN (''018'') and BOL_FECHA between to_date(:FECHA1,''DD/MM/YYYY'') and to_date(:FECHA2,''DD/MM/YYYY'') ' ;
Add_Parameter(lista,'MOVIN',TEXT_PARAMETER,WHERE_CLAUSE);
Add_Parameter(lista,'SUCU',TEXT_PARAMETER,:BLK_DATOS.COD_SUCURSAL);
Add_Parameter(lista,'FECHA1',TEXT_PARAMETER,NVL(:BLK_DATOS.TXT_FECHA_INICIO,TRUNC(SYSDATE,'MM')));
Add_Parameter(lista,'FECHA2',TEXT_PARAMETER,NVL(:BLK_DATOS.TXT_FECHA_FINAL, LAST_DAY(SYSDATE)));