Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
shair_abbas
Partner - Creator
Partner - Creator

Date Parameter Issue in Qliksense Extraction

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’

6 Replies
shraddha_g
Partner - Master III
Partner - Master III

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
Partner - Creator
Partner - Creator
Author

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
Partner - Creator
Partner - Creator
Author

Hi Sharddha,
     Not working...

shraddha_g
Partner - Master III
Partner - Master III

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

shair_abbas
Partner - Creator
Partner - Creator
Author

Yes