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!

APEX_ITEM.TEXT force date data type.

YovinJul 15 2016 — edited Jul 29 2016

Hello.

I have the following field in an interactive report sql:

APEX_ITEM.TEXT(26,delivery_date,10,NULL,' style="text-align:center" ') delivery_date,

This field maps to the EBS database in an attribute. As the attribute is a varchar, it accepts and value even if its not a date. I also tried to change the property of the field to format mask date, Still any text can be input and saved.

Can someone tell me how to force a date to be entered for this field.

Brgds

This post has been answered by PMON on Jul 18 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2016

Added on Jul 15 2016

#apex-discussions

6 comments

427 views