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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IR Date Filter Bug - APEX 21.2 and 22.1

SaraBMay 5 2022

Hi
We're running APEX 21.2.5 and have a problem where the hours and minutes select lists are displayed the wrong way round when filtering on a date column in an interactive report:
image.pngIn the above screenshot the time is 13:45, but the minutes are displayed first. This does not prevent the filter from working, the correct time is used, it is just a UI issue.
I have reproduced this issue on apex.oracle.com with a very basic interactive report, see https://apex.oracle.com/pls/apex/r/sblair/testing-ir-date-format/home. So this is also an issue in 22.1. It is only when there is a time component in the date format for the column, so you will need to filter on the Created Date column. (Actions - Filter - Column = Created Date - Click the datepicker icon).
If it's of help, I believe this might be a CSS problem as although the elements are set to float right, this is being ignored:
image.pngIf you take off the float:none!important, then the select lists are displayed correctly.
Is anyone able to advise or provide a fix?
Many thanks
Sara

Comments
Post Details
Added on May 5 2022
0 comments
447 views