Skip to Main Content

Filtering on date in Interactive report

BelindaJan 26 2020 — edited Jan 27 2020

Basic table-  name,DOB

DOB inserted as TO_DATE('01/01/1968','DD/MM/YYYY')

In the object browser I can query this table to look for date 01/01/1968 and it returns 1 row as expected

I run the same query in an oracle apex interactive report based on this table but get zero rows.

If I change my search in the interactive report to 1/1/1968 1 row is returned.

Why does the basic reporting in the object browser work but the oracle Apex interactive report filter is not able to search and find the same data?

Any information is appreciated.

Post Details
Added on Jan 26 2020