SAP date format

[rajtechnocraft]

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

[Anonymous · Accepted solution]

Hi,

please try it with:

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

...

SQL Select ERDAT VKORG from VBAK

WHERE ERDAT => '$(varDATE)' ;

[rajtechnocraft]

Thanks Gencsoy,

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

Regards