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!

filter on date in IG with the exact upload date?

Souzan-OracleAug 5 2019 — edited Aug 5 2019

Hello,

I am using the IG for the data load upload, but it seems once all the information it is reflected within the table i cannot filter based on the date, as it grants me the options (last year, last month,last week, last days, and in future), the column is set as date to be created a trigger on each upload

:new.created := localtimestamp;

using Application Express 19.

however, i would like to be able to filter the exact date of the upload and it is not allowing me.

pastedImage_0.png

and the same issue, i have a column set as date ( the information reflects within the uploaded information) the column is set as date, but for some reason when i want to filter on the date it is not allowing me at all and it does not even reflect suggestions.

pastedImage_1.png

Can anyone advice, on how i can manage this?

Thank you!

Comments
Post Details
Added on Aug 5 2019
5 comments
491 views