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

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.

This post has been answered by Dasshini Ravi on Apr 6 2026
Jump to Answer
Comments
Post Details
Added on Apr 5 2026
5 comments
116 views