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!

APEX 21.2 Date Picker Date format issue for September dates

stealth1976Dec 6 2021 — edited Dec 6 2021

sept.jpg (19.23 KB)Hi
We have recently updated all our applications from 18.1 to 21.2.
Everything appears ok except the date picker. Our date format is DD-MON-RRRR or DD-MON-RRRR HH24:MI with time.
This works fine until we select september. The date picker formats the month to be "Sept" not "Sep" this causes errors to raise "Literal does not match format string". If we choose any other month it works fine. If we change to a text box and manually input the date it works fine even for september.
Has anyone else come across this? If so did you find a solution? At present we have to get a 3rd party plugin which is not ideal as the plugin is deprecated.
Any help greatly appreciated

This post has been answered by stealth1976 on Dec 7 2021
Jump to Answer
Comments
Post Details
Added on Dec 6 2021
1 comment
1,168 views