Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a script that where I state the following:
where tl.final_pricing_dt > '2016-08-29'
Is it possible to replace the date with a variable for yesterday?
Thanks,
Daniel
Sure, may be like this:
LET vDate = Date(MakeDate(2016, 8, 29), 'YYYY-MM-DD');
Where tl.final_pricing_dt > '$(vDate)';
Hi,
vYesterday=Today()-1
Thanks,
Nitin
Thanks for the reply.
Will that create a moving date? For example if I run the report tomorrow I would like the date to be today.
ie Run on 01/09/2016 and pricing greater than 31/08/2016.
Regards,
Daniel
May be this:
LET vDate = Date(Today() - 1, 'YYYY-MM-DD');
Where tl.final_pricing_dt > '$(vDate)';
Yes , Today() function gives you today's date every time you open or reload the qvw .
Thanks
Nitin
try lik
let vdate=Date(Today()-1,'YYYY-MM-DD');
[test]:
LOAD * INLINE [
Maand, ID, myDate
1, 2, 2014-12-14
2, 3,2016-09-15
]
Where myDate>'$(vdate)';