How can i convert any date format to "dd/mm/yyyy"

[Rowley101]

i get multiple dates i different formats,
dd-mm-yyyy
dd.mm.yyyy
01-apr-2020
but they all need to be in the same format
dd/mm/yyy

is there a code to change them all the that format?

[ManiPrajwal_K (Mani Prajwal Katta)]

@Rowley101, Convert the String to Date using CDate.

Then you can modify that converted date to your required format.
Eg. CDate(< String Var >).toString(“dd/MM/yyyy”)

[ppr (Peter Preuss)]

How to Convert multiple column date format in data table using linq(With out foreach)

@BalaM1510 the main building block is an array with formats: [grafik] which can be used DateTime.ParseExact(YourDateString, arrFormats, YourCultureInfo, DateTimeStyles.None) from your question it can be derived: a column with date strings is the input for a dateTime.ParseExact the conversion result will update the value within the column LINQ could be used for this. But as we have to be prepared for conversion fails LINQ is less helfull for this due: ALL or Nothing is converted intran…

[Yoichi]

Hi,

This is FYI. As UiPath handles datetime as InvariantCulture, the following result won’t be same.

CDate("05-06-2021").ToString("dd/MM/yyyy")

returns 06/05/2021

DateTime.ParseExact("05-06-2021","dd-MM-yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

returns 05/06/2021

If you need to prevent the above, set the following expression using Assign

System.Globalization.CultureInfo.CurrentCulture = New CultureInfo("es-ES")

Regards,