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!

Bar chart date format

User_N2QAYNov 12 2019 — edited Nov 13 2019

I have a bar chart, which has an "X" axis with dates. However, the dates are shown in the format "YYYY-MM-DDDTHH: MI: SS", and I want the date to be displayed as "DD-MM-YYYY". I have tried the following:

  1. At the source of the data (SQL Query), I performed the casting with "TO_CHAR", and it is displayed in the desired format, however, the order of the dates is no longer chronological.

  2. I have changed the values of the format of dates in "Shared Components" -> "Globalization", however these have no effect on the application.

  3. I set a format such as "Date - Short" to the "X" axis on the bar chart, and it doesn't take effect either.

Thanks in advance for the help you can give me.

pastedImage_1.png
This post has been answered by Hilary Farrell-Oracle on Nov 13 2019
Jump to Answer
Comments
Post Details
Added on Nov 12 2019
#apex, #apex-discussions
7 comments
3,456 views