Can you help me out on this code and logic
I WANT TO CONVERT THIS 5/24/2021 TO 5/24/2021 AFTER PERFOMING DYNAMIC ACTION.
declare
m_date date;
duration number;
begin
number := 91;
SELECT to_date(:P35_DATE_OF_INVESTMENT) + duration into m_date FROM dual;
return to_date(trunc(m_date),'mm/dd/yyyy');
end;
maturity date = date of investment + duration.
i want to get the date in these format 5/24/2021 not these 5/24/2021 .
Thanks
Vinish Kapoor
For the Oracle Apex date item, you need to convert it to date with the date format. I am assuming that you are already displaying the date in the mm/dd/yyyy (05/25/2021) format. Below is the example:
Richmond
Thank you for the prompt feedback.
code works but
still having the same issue on date item/colum.
See image
Vinish Kapoor
You need to turn off Escape Special Characters setting for the dynamic action you created for the date. Then it will be fine.
Richmond
Great
Issue now resolved
Thank you