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.