I have a form (APEX version 24.2) with a date picker. What I want is a “_Are you sure?_” confirmation if the chosen date is more than a week in the past.
Trying with a “Confirm” dynamic action displays the Confirmation dialog prompt but has two problems:
1. After the user presses OK, it returns to the picker instead of inserting the date into the item field.
2. A browser-side condition based on sysdate-7 doesn't seem to work.
I can solution this successfully using a purely custom JavaScript dynamic action (and not using the “Confirm” action) but it would be better to use native APEX components. Does anyone know how to accomplish this without using a custom JavaScript confirmation and pop-up?