Date Parameter Issue in Qliksense Extraction

[shair_abbas]

Hi guys,
    Please Help me out i am trying to extract data from Oracle DB on particular date but somehow i am unable to do this i have tried following script

LIB CONNECT TO 'Snd Pro';

CASHMEMO_DETAIL:

SQL SELECT  *

FROM "SNDPRO"."SCHEME_DISCOUNT_DETAIL"

where TO_CHAR(cast(DOC_DATE),'ddMONyyyy')= '01NOV2017';

this particular script is running properly on some table but get ‘0’ no of records on other tables.

I have tried following date format but getting 0 no of rows

DOC_DATE >= ’01-NOV-2017’

DOC_DATE >= ‘vDate’; // in vDate we have value ’01-NOV-2017’

DOC_DATE >= ‘01/11/2017’

DOC_DATE >= ‘01/NOV/2017’

DOC_DATE >= ‘11/01/2017’

DOC_DATE >= ‘2017-11-01’

[shraddha_g]

try date format as 01112017

[OmarBenSalem]

Try this ;

LIB CONNECT TO 'Snd Pro';

CASHMEMO_DETAIL:

load * where  date(DOC_DATE,'DDMMMYYYY')= '01NOV2017

SQL SELECT  *

FROM "SNDPRO"."SCHEME_DISCOUNT_DETAIL";

what is the format of the DOC_DATE? suppose it's 16/03/2017 ; and it's not a date..

you'd do like this

load * where  date(date#(DOC_DATE,'DD/MM/YYYY'),'DDMMMYYYY') = '01NOV2017

[shair_abbas]

hi Omar,
    I don't want to apply condition on load statement.It should be implemented in Select statement because i am working on incremental extraction.Data type of DOC_DATE in TIME_STAMP.
let me add one more this  DOC_DATE = '01-NOV-2017' works fine in Qlikview. 

[shair_abbas]

Hi Sharddha,
     Not working...

[shraddha_g]

is it working in qlikview for same table n same script?

[shair_abbas]

Yes