I have this example, color green its what i need i need to get the all Wednesdays starts the fisrt day in (July 1 2022) and (ends the last day of June 2023).
This is the case if the current day its WEDNESDAY set the name (“Week XX september”) and if the month contains more days like this example
The color green its the current day, but if i run the bot 30 of september set the string (“Saldo al XX of september”)
NOTE:
WEDNESDAYS = SET (“Week XX september”)
AND
THE LAST WEEK OF THE MONT IF THE MONTH CONTAINS 28,29,30,31 → SET (“Saldo al XX of september”)
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.
Anil_G
arjunshenoy
Yoichi
gibl.rpa
Hazem_Saleh
adishjain
yikwen.goo
trajkoskisara
Parvathy
DanRagh