Hello, have a good day.
I made a new project, and created 3 variable of type System.DateTime.
One is startdate, another one is enddate and the another one is data.
This data variable is set to the value of startdate as begining date.
Then, I had tried a Do While activity, to lookup after each next day.
The condition for this working loop is:
At end of the loop body, I had added a Set Variable Value activity.
This will actually add a new day to the current data being iterated:
data = data.addDays(1)
At beginning it is an If activity, that looks for the currnt day.
If the current day is “Wednesday”, then do some tasks for that day.
The condition of this If statement is the following:
data.DayOfWeek.ToString = “Wednesday”
In place of this If statement you can add the working sentences.
You can add this date to a data table, or write directly to Excel.
Or create an array, or a list and add each day to this collection.
This is up to you, how you’ll write this data, and how to use it.
I don’t know very well, how do you want to store all these values.