Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I am trying to do a increment load based on date but it is not working could you kindly help me or point where i am wrong
I have a variable
let vStartdate = date(today()-5,'YYYYMMDD');
in the QVD file i have a field OpDate in the format DD/MM/YYYY
my condition is
LOAD *
;
SQL
select X, Y, Z
FROM dbo.ABC
WHERE OpDate between '$(vStartdate)' and '$(vprvdayop)'
Concatenate
LOAD *
FROM
Where Date(OpDate, 'YYYYMMDD') < $(vStartdate);
Try something like this:
let vStartdate = date(today()-5,'DD/MM/YYYY');
Table:
LOAD *
;
SQL
select X, Y, Z
FROM dbo.ABC
WHERE OpDate between '$(vStartdate)' and '$(vprvdayop)'
Concatenate (Table)
LOAD *
FROM
Where OpDate < $(vStartdate);
Regards,
MB
Try something like this:
let vStartdate = date(today()-5,'DD/MM/YYYY');
Table:
LOAD *
;
SQL
select X, Y, Z
FROM dbo.ABC
WHERE OpDate between '$(vStartdate)' and '$(vprvdayop)'
Concatenate (Table)
LOAD *
FROM
Where OpDate < $(vStartdate);
Regards,
MB