to get previous year data 2019
Hi All,
Working in OPM 12.1.3
Please i need help to get data of 2019 from below query
select * from ra_customer_trx_all
where trunc(to_char(trx_date,'YYYY')) = nvl(trunc(to_char(:p_date_to,'YYYY')-1), to_char(add_months (trunc (sysdate, 'YEAR'), -1 ) ,'YYYY'))
and to_number(to_char(trx_date,'MM')) <= nvl(to_number(to_char(:p_date_to,'MM')), to_char(add_months (trunc (sysdate, 'MONTH'),-1 ) ,'MM'))
Regards