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!

DATE RANGE SMART FILTER SAME DAY

Hello,

The new DATE RANGE Smart Filter is in my opinion not well designed - if I filter exactly one day it will not result anything. (date is TRUNCed) When Debugging is activated, I can see that APEX internally queries the data saying ≥ FROM and < TO.

Do you know of any workaround? (beside not using a smart Filter for a Date range and substituting it with a BETWEEN Operator?)

Your help is very much appreciated,

Sebastian

This post has been answered by Carsten Czarski-Oracle on Nov 7 2025
Jump to Answer
Comments
Post Details
Added 18 hours ago
4 comments
43 views