topic AW:SAP date format in QlikView

SAP date format

rajtechnocraft — Tue, 10 Nov 2009 16:45:22 GMT

Hi all,

I am trying to create a qvd fetching data from sap system through connector. I am unable to filter the data on date while creating qvd.

CUSTOMCONNECT TO "Provider=QvSAP Connector;ASHOS T=192.168.11.24 3;SYSNR=00;CLIE NT=252;XUserId= eDNeeYRNJbaMXUV MXLDA;XPassword =GHXfMXVMXDZCGa FMRRJB;";

Table:

LOAD

FKDAT;

SQL SELECT FKDAT

FROM VBRK where FKDAT > '2007/01/02' ;

Its geting filtered on basis of year but not month and date.. i have tried using other formats of date also like 2007.12.23

or 2007-12-23 .

Regards

Raj

AW:SAP date format

Anonymous — Tue, 10 Nov 2009 17:01:44 GMT

Hi,

please try it with:

let varDATE = date(now(),'YYYYMMDD');

...

SQL Select ERDAT VKORG from VBAK

WHERE ERDAT => '$(varDATE)' ;

AW:SAP date format

rajtechnocraft — Tue, 10 Nov 2009 17:26:24 GMT

Thanks Gencsoy,

Apreciate your help. My problem is solved with your answer.

Regards