Date in email is format of 28/09/2025 and I need to select whatever date comes in email

Help Studio
1

I can automate everything, but I need some guidance on the Date pickers to choose the right date.

On websites the month is in format of October or November instead of 10 or 11.

Please guide with date pickers.

2

hi, @Rakshith To handle date pickers where the month shows as text (like “October” or “November”), here’s a straightforward approach:

  1. Click to open the date picker on the website.

  2. Use a Get Text activity to read the currently shown month.

  3. Loop clicking the “Next” or “Previous” button until the displayed month matches the month you want (e.g., “October”).

  4. Once the month matches, click on the day you want using a dynamic selector.

Use variables for the month and day in your selectors so the automation works for any date. This way, your bot can handle months shown as text easily and select the right date dynamically.

Hope this helps!

3

Hello @Rakshith if you month is number like 09 then use this
emailDate = DateTime.ParseExact(emailDateString, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture)

AND if it is full month name then use this
emailDate = DateTime.ParseExact(emailDateString, "dd/MMMM/yyyy", System.Globalization.CultureInfo.InvariantCulture)

and if it is only like Sep then use this
emailDate = DateTime.ParseExact(emailDateString, "dd/MMM/yyyy", System.Globalization.CultureInfo.InvariantCulture)

Cheers

4

Hi @Rakshith

Extract the date from the email using regex, then parse it and use the parsed values to select the corresponding date in the date picker.

Example:

Dim emailBody As String = "The date is 28/09/2025"
Dim match As Match = Regex.Match(emailBody, "\d{2}/\d{2}/\d{4}")
Dim parsedDate As DateTime = DateTime.ParseExact(match.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture)

Use the parsed parsedDate to select the day, month, and year in the date picker.

If helpful, mark as solution. Generated by LLM Happy automation with UiPath! :white_check_mark:

5

Hello @Rakshith,

Use linq :-

target = arrData.Cast(Of String)().
Where(Function(x) Date.ParseExact(x, “dd-MMMM-yyyy”, System.Globalization.CultureInfo.InvariantCulture) = Date.ParseExact(“07-October-2025”, “dd-MMMM-yyyy”, System.Globalization.CultureInfo.InvariantCulture)).
FirstOrDefault()