Read and write date from excel to web using uipath

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)


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

@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")

Hi @Mehdi_KAMALI_FR

Try this

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

Regards,

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

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

@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.

Thank’s Ashok,
Here’s what i got


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

@Mehdi_KAMALI_FR,

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

1 Like