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 ...
SQL SELECT *
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,
Go to Solution.
WHERE DateField = '20110111';
Hope that helps.
after some tries, I found the way:
WHERE DateField <= '20080303' and DateField >= '20080302';
Now I can also do this.
Thanks Miguel for your answer,
I was writing my own conclussions when you posted yours (XD).
As we say, that way works.
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';
[BUKRS]&[BELNR]&[GJAHR] as BPKFServerKey,
'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.
Thanks in advance.
Try using this code:
let date = '20111215';
where CPUDT = $(date) or AEDAT = $(date);