Looping through dates in API call.

[jeckstein]

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.