Skip to Main Content
Forums

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!

Date picker validation in Apex 4.2

Sruthi TamiriNov 10 2015 — edited Nov 10 2015

Hi Team,

We have created one date picker in APEX 4.2 as shown below

pastedImage_0.png

Under that specific item under default i had mentioned as "to_char(sysdate,'fmDay,Month fmDD,YYYY')", so when page loads will display current date.

1. Now problem is that, if they change data manually i.,e today is Nov -10th Tuesday, but if they enter as "Monday,November 10,2015" then we will receive error as "Error ORA-01851:literal does not match format string", since Nov 10th is Tuesday, but not Monday.

2. I had provided suggestions that, to make that filed read only, but user wants another approach. Could you please provide best approach to handle this request.

Regards,

Sruthitamiri
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2015
Added on Nov 10 2015
#apex-discussions
3 comments
962 views