Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am pulling a simple table from the BW system and I need to pull this table by giving parameters from the system.
How can I add the date field that I have given as a parameter as a field and all date save one qvd?
Let vdate1='20240101';
Let vNow = Date(Now(), 'YYYYMMDD');
for test= '$(vdate1)' to '$(vNow)'
OrderDate:
LOAD
"PRODUCTION",
"OK",
"KO",
"FTT"
SQL SELECT
"PRODUCTION",
"OK",
"FTT"
FROM ORDERS
('PLACEHOLDER'=('$$ILKTRH$$','$(test)'),'PLACEHOLDER'=('$$SONTRH$$','$(test)'));
next
load
...,
makedate(left('$(test)',4),mid('$(test)',5,2),right('$(test)',2)) as date
...