I’m trying to extract a report every single day starting the 1st day for the previous month.
The field I use is as below:
After put in the date the robot will click Run and then it will go back to the process to put in the date. But this time with the DAY added by 1. The robot then will repeat the process until end of the month.
I just could not find a way to do it using for each loop (not even sure if this is the correct method)
use foreach method in value field type the Enumerable.Range(1,datetime.DaysInMonth(cint(now.ToString(“yyyy”)),cint(datetime.Now.AddMonths(-1).ToString(“MM”))))