How can I get the date data taken with the parameter as a field?

[krmvacar]

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

[ali_hijazi]

load
...,

makedate(left('$(test)',4),mid('$(test)',5,2),right('$(test)',2)) as date
...