Can anyone help me, how can i show previously stored data in DB for due_date column (date stored as 07-MON-19) but in IG i need it to display as YYYY ie, 2019 instead of 19. ex: 07-MON-2019
i tried couple of things mentioned below:
1. replace(TO_CHAR(a.DUE_DATE,'DD-MON-YYYY'),'-00','-20') DUE_DATE
both giving me date as expected that is 07-MON-2019 but as am using IG, due_date column is date picker so when i edit and change the date am getting error mentioned below:
- An unexpected internal application error has occurred.
Oracle apex 5.1 11g
Thanks in advance