Hi everyone,
I am relatively a newbie to apex and need some help. How can I successfully make the dynamic action to work.
I have a table with a date column named "reg_date". The date format is MM/DD/YYYY.
In APEX I have a page with a classic report and 2 date picker items. One is a "Fromdate" and the other "Todate". I want use the 2 date-picker items to filter the classic report with a dynamic action. The dynamic action is to refresh the classic report when the start-date is changed.
This is the SQL Query in the source section of the region but it doesn't work. When I change the dates in the date-picker the report doesn't display.
select ID, FIRST_NAME, LAST_NAME, GENDER, REG_DATE from TEST_TABLE where TO_CHAR(REG_DATE,'MM/DD/YYYY') BETWEEN :P2_FROMDATE AND :P2_TODATE ORDER BY TRUNC(REG_DATE) DESC;