Qlik Community

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where clause with Date comparison in SAP Connector

Hi,

I'm trying to get rows from some SAP tables, depending on the date they've been created/modified.

The "SQL" statement I'm trying to use looks like:

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll ...

Load *;

SQL SELECT *

FROM  TABLE

WHERE DateField = '2011/01/11';

STORE  TABLE INTO  ANY.QVD;

How can I define correctly my date definition for my where clause? I'm trying almost everything but it doesn't work.

Thanks for your help in advance,

Aitor.

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi Aitor,

Try instead

WHERE DateField = '20110111';

Hope that helps.

Miguel

View solution in original post

5 Replies
Miguel_Angel_Baeyens

Hi Aitor,

Try instead

WHERE DateField = '20110111';

Hope that helps.

Miguel

Not applicable
Author

Ok,

after some tries, I found the way:

LOAD

*;

SQL SELECT *

FROM  TABLE

WHERE DateField <= '20080303' and DateField >= '20080302';

Now I can also do this.

Not applicable
Author

Thanks Miguel for your answer,

I was writing my own conclussions when you posted yours (XD).

As we say, that way works.

Thanks again,

Aitor.

Not applicable
Author

Making this script more complicated, anyone know how to write it, storing the date value into a variable?

My scripting code looks like this:

$date = '20111215';

BKPF_Server:

Load

[BUKRS]&[BELNR]&[GJAHR] as BPKFServerKey,

[BUKRS],

[BELNR],

[GJAHR],

'BKPF-Server' as Provenance_BKPF;

SQL Select BUKRS BELNR GJAHR CPUDT AEDAT from BKPF

where CPUDT = '$(date)' or AEDAT = '$(date)';

But using variable it brings me 0 records instead of the 26K records using the hand-typed value e.g.:'20081003' in 'YYYYMMDD' fromat.

I trid modifying date variable with Date(Date#(date,'YYYYMMDD'),'YYYYMMDD') and similar things, but nothing seems to work.

Any idea?

Thanks in advance.

Aitor.

Not applicable
Author

Hi,

Try using this code:

let date = '20111215';

.

.

.

.

where CPUDT = $(date) or AEDAT = $(date);

regards,

Ronald