Hi,
Currently I having problem retrieving data by using OLE connection from MSSQL. Below is the script used.
Output:
SQL
select
Top 100
*
from
SourceTable
where
DateValue >= convert(DATETIME,'2016-09-21 00:00:03',206)
and DateValue < convert(DATETIME,'2016-09-21 10:25:03',206)
;
However when I try the same code in the native MSSQL client. it does work.
Further troubleshooting, Qlikview manages to display data without using date in filtering criteria.
Output:
SQL
select
Top 100
*
from
SourceTable
where
Column1 = 'A'
;
Is there a way to retrieve data from MSSQL within a specific date range ? I had try several different style but with no luck, like,
- datediff( day ,DateValue ,'2016-09-21 00:00:03' ) >= 0 and datediff( day ,DateValue ,'2016-09-21 10:25:03' ) <0
- DateValue between '2016-09-21 00:00:03' and '2016-09-23 10:25:03'
- Cast( replace( convert( varchar(30) ,DateValue ,112 ) +convert( varchar(30) ,DateValue ,108 ),':','') as bigint ) >= 20160921000003 and Cast( replace( convert( varchar(30) ,DateValue ,112 ) +convert( varchar(30) ,DateValue ,108 ),':','') as bigint ) < 20160921102503
But with no success. Is there a way to achieve this ? or is it a limitation Qlikivew & OLEDB ?
Thanks.
