Read and write date from excel to web using uipath

Help Studio
1

Hi everyone, hopefully someone can help to write date with (mmm d, yyyy) format from Excel to Website ex: Nov 3, 2024
And do i need to put a varibale before or in Type into activity ?

Thank you in advance

Changement de date_Test 1.zip (2,5 Mo)

Type into
Type into350×233 8.45 KB

The image shows a spreadsheet cell with a yellow background containing the header "StartDate" and the date "Nov 3, 2024". (Captioned by AI)

2

@Mehdi_KAMALI_FR,

Use this way directly into Type Into activity

DateTime.ParseExact(CurrentRow("StartDate").ToString,"MMM d, yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("MMM d, yyyy")
3

Hi @Mehdi_KAMALI_FR

Try this

The image depicts a UiPath workflow that reads a date range from an Excel workbook and displays each date in a message box. (Captioned by AI)
The image depicts a UiPath workflow that reads a date range from an Excel workbook and displays each date in a message box. (Captioned by AI)1040×720 25.3 KB

DateTime.FromOADate(Convert.ToDouble(CurrentRow("StartDate"))).ToString("MMM d, yyyy")

Regards,

4

Hi @Mehdi_KAMALI_FR

Try this way,

Str variable = DateTime.ParseExact("Yourinput",{"MMM d, yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MMM d, yyyy")

If you have more input format means you can add in the array

Regards,
Gowtham K

5

Thank’s everyone for reactivity and help, here is what i got @ashokkarale do i need to create a variable ?
@Lrtetala I try what you send but should i create a loop before the type into ?

Sorry guys I just started using UiPath recently

Thank you !
MK

The image shows a UiPath Studio interface with a sequence of activities including keyboard shortcuts and date input, and an error message indicating an invalid DateTime chain. (Captioned by AI)
The image shows a UiPath Studio interface with a sequence of activities including keyboard shortcuts and date input, and an error message indicating an invalid DateTime chain. (Captioned by AI)1280×821 64.7 KB

6

@Mehdi_KAMALI_FR,

Ok let’s put this in a variable before passing to the Type Into. Also log CurrentRow("StartDate").ToString just to see what we are getting and how we need to format it.

7

Thank’s Ashok,
Here’s what i got

The image shows a UiPath Studio workflow configuration with an error message indicating an unrecognized string as a valid DateTime format. (Captioned by AI)
The image shows a UiPath Studio workflow configuration with an error message indicating an unrecognized string as a valid DateTime format. (Captioned by AI)1450×803 56.2 KB

Changement de date_Test 1 (2).zip (2,5 Mo)

8

@Mehdi_KAMALI_FR,

Add a log message before assign activity to log CurrentRow("StartDate").ToString

1 Like
9

Hi everyone, i think it works with @lrtetala solution
Thank’s all, really appreciate your help !