Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
singbittoo
Contributor

Issue with date filter using OLEDB connection for oracle

SELECT *
FROM some_table
Where Date>'01-DEC-18' and some other conditions;

i have the above query, when using ODBC connection its working fine and i am getting the required data all the filters are working fine, but when i am using OLEDB connection the date filter is not working but other filters are working and its loading all the data present in the database for the other filters, any idea what is happening ?

2 Replies
mwoolf
Honored Contributor II

Re: Issue with date filter using OLEDB connection for oracle

Probably needs the date in some specific format.

Maybe: '2018-12-01'

singbittoo
Contributor

Re: Issue with date filter using OLEDB connection for oracle

i am running the exact query with ODBC connection, i am running the exact query in Oracle SQl Developer its working fine there, is there any thing with OLEDB that we need to change the date format ??