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!

Not a valid date value displayed when Item type date is calculated by a dynamic action

Christian Pitet.13 hours ago

Hi,

Under , in a form, there is an element type DATE, P7_DATE_PROCHAINE_ACTION2. Which value is calculated with Dynamic action according to the value of a static button radio group which returns a number of days. The calculation is a PL/SQ Expression type:

CURRENT_DATE + TO_NUMBER(:P7_STATUT_CONTACT)

It works well, but the value displayed in the field P7_DATE_PROCHAINE_DATE is not a date format, but instead a character string, like that for example:

07/04/2026

This is a screenshot:

Best regards.

Comments
Post Details
Added 13 hours ago
3 comments
35 views