How to output GL Amount for two months with parameter?
I need to output GL amount for two months with BIP.
There should be one parameter for setting Period. Then I need to output GL Amount for the month set by the parameter and the previous month of it.
ex.) when I set parameter with '202502', amount should be output for '202502' and '202501'.
I tried this SQL but it didn't work.
WHERE GL_BALANCES.PERIOD_NAME IN (:PERIOD_NAME,TO_CHAR(ADD_MONTHS(TO_DATE(:PERIOD_NAME,'MON-YYYY'),-1),'YYYYMM'))
If you know any solutions, please let me know.
Tagged:
0