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

krmvacar — Fri, 22 Mar 2024 13:22:26 GMT

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)'));

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

ali_hijazi — Sat, 23 Mar 2024 07:23:31 GMT

load
...,

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

topic Re: How can I get the date data taken with the parameter as a field? in App Development

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

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