Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Auto Populate a Date based on selected Date

Idkfa2Oct 8 2020

Hello,
I've seen some answers using Search but none seem to fit what I am doing.
I'm looking to have a date auto populate based on a selected date using the date picker. From what I understand the page will need to be saved (refreshed) and this will show with a Dynamic Action. Is there another way of doing it such as using Expressions? I tried to use :P_item + 10 but I keep getting the error ORA-06502: PL/SQL: numeric or value error: character to number conversion error. I tried to use the TO_DATE function but I get a similar error. I'm also still on version 5 of Apex.
For example, I'd like to have :P_datepicker to select a date, then add N-days and :p2_display_only will populate and save to the table.

This post has been answered by InoL on Oct 8 2020
Jump to Answer
Comments
Post Details
Added on Oct 8 2020
9 comments
831 views