Creating a variable to click a different date in calender with every loop

[Reghardt]

I have created a process which will need to read data from an excel sheet. That data will then be used to complete a form as part of an application form.
There is a date component which looks like an actual calender, the year is a dropdown where I used a select item, month is a dropdown and where I used a select item. But the day is where I need to do a click.
I need to loop through the process using different data and specific dates. I need some assistance setting up the variables for each loop?
I have created the variable DebitOrderDay, not sure about the other variable setup.
I have added a screenshot to see what the calender looks like.

This is what my process looks like to select the date. I just dont know how I am going to automate the day selections.

[Anthony_Humphries]

It looks like there is a place to type the date in. Can you use a Set Text activity to set the date directly rather than using the date picker?

[Reghardt]

@Anthony_Humphries

an you use a Set Text acti

Unfortunately not editable. If I could type the date I would have done so.

[Anthony_Humphries]

There are some solutions in the post below. It will involve writing logic which will iterate through each of the years, months, and days.

Date picker

You have to handle each of the 3 part in seperately(date, month & year). Each of them will have a respective selector that you may have to identify. Month & Year could be handled using Select Item activity, whereas the dates could be handled using Click Activity. Check these threads, Thanks, Rammohan B.