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.