Where clause with Date comparison in SAP Connector

[#1]

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.

[Miguel_Angel_Baeyens · Accepted solution]

Hi Aitor,

Try instead

WHERE DateField = '20110111';

Hope that helps.

Miguel

[#3]

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.

[#4]

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.

[#5]

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.

[#6]

Hi,

Try using this code:

let date = '20111215';

.

.

.

.

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

regards,

Ronald