Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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 ?

Labels (4)
2 Replies
Highlighted
Master II
Master II

Probably needs the date in some specific format.

Maybe: '2018-12-01'

Highlighted
Creator
Creator

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 ??