I have a load statement like this
Data:
Load
Dim_1,
Dim_2,
Met_1,
Met_2
From
[
[http://localhost:5526start-date%3d yesterday %26end-date%3d today %26metrics
(qvx);
I need to make yesterday and today variables and loop them through the following date range.
2015-08-31 through today 2016-12-26.
The variables need to be in these date format YYYY-MM-DD.
so
the 1st pull should be yesterday=2015-08-31 today=2015-09-01
the 2nd pull should be yesterday=2015-09-01 today=2015-09-02
the 3rd pull should be yesterday=2015-09-02 today=2015-09-03
this pattern should continue until yesterday=2016-12-25 today=2016-12-26
Thanks in advance.
