Dynamic Calender Selector (I challenge you to try)

(0) Share

Report

Posted on by jkingno1

141

Hi,

This is a challenging one. I have a program which is 1/1 exclusive to our company and I need help to try create an AI automation which selects the dates based of a user input. E.g. user input = January, 01, 2023 to January, 31, 2023. This Input will trigger the automation to select these specific dates in the program. In theory id ideally like to enter any dates (Any years as well) and the automation selects the correct dates.

At the moment all I can think of is creating 12 'If' bases (Based of each month) (only for one year). And the Input variable triggers one of the 12 'If' to click a specific location(s) in the window of the program. I feel someone may have some idea out there that is better than mine so I thought id share this. I have an image for reference of the style of calendars we have in the program. The left box is the first date input and the second is the second date input (The 'to' date).

Calender select.jpg

Any responses id appreciate. Thankyou!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @jkingno1

I have tried simmilar kind of problem using other RPA tools.

The logic i have used is.

1. Extract the month and year details from date we need to select.

2. Now open the calendar dialog, check what is the current month and year provided there, check whether they are higher or lower than given date, if same select the date

if higher than given date, click left side arrow to move backwards, until u get the desired month year
if lower than give date, click right side arrow to move forward until u get desired month year,

Then select date.

Hope the logic helps !

Was this reply helpful? Yes No
Jdelavega 106 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @jkingno1

Excuse me, my code is in Spanish. I hope you can understand it.

First, the month to be analyzed is transformed from a number to a date for its later use.

Then, the month in letters is obtained from the calendar and compared with what was obtained in the previous step. In case of a match, it will select the chosen date. If it doesn't match, it will move the arrow to the right, moving on to the next month and restarting the evaluation.

Let me know if this was helpful!

Was this reply helpful? Yes No