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,
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.