extracting Data from Sql server

[ebrahimaljafri]

hi Qlikers,

i am extracting data from SQL server for certain period of date using SQL where clause column date >= '20180601' and column date<= '20180831' ; actually , i am only getting data for jun first only and then application save as there are no more data.

note i have check data in SQL server using SQL server manager using same SQl query used in qlik  and there are data for all jun ,July and august.

has any one faced such an issue ??

[atoz1158]

Try using

MyDate >= '2018/06/01' AND MyDate <= '2018/08/31'

Regards

Adrian

[ebrahimaljafri]

thank you atoz1158‌

in my scenario i do not think is the issue because of the date format . in fact . each  column date record = '20180801000000' .

does windows server memory and hard disk space might cause such an issue ?