Hi,
i have folders created on each day [20201114], so there are 12 months folders created based on date.
i want my pipeline to copy the files from each folders ; Starting from current date [20201114] till 6 months back folders data [20200514]
i have created two variables start date [@formatDateTime(AddToTime(utcnow(), -6, 'Month'), 'yyyy-MM-dd')] and end date [@formatDateTime((utcnow(), 'yyyy-MM-dd')]
now how to increment dates one by one from start to end date
Now i want the copy activity to increment 1 + day to this variable and copy the data from respective date folder
for eample: varibale output is [2020-05-14] >> adding +1 [2020-05-14 + 1] = [2020-05-15]>> copy activity should search for the folder name [2020-05-15] and process
like wise the process should continue from [2020-05-14] till [2020-11-14]
how to achieve this through ADF Pipeline


