Convert Date to a Particular Format Regardless of the Source Format

[MartianxSpace (Chitti)]

Hi,
I want to convert a string to date with a format like (MM/dd/yyyy) so I used DateTime.ParseExact method as mentioned below.

DateTime.ParseExact(invoiceDate.ToString(),"yyyy-MM-dd", Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy")

But just now I realized that the source (invoiceDate) format is dynamic. Sometimes it can be MM/dd/yyyy or dd MMM yyyy or dd-MM-yyyy etc.

is there any way to convert it to MM/dd/yyyy regardless of the source (invoiceDate) format?

[Srini84 (Srinivas)]

@MartianxSpace

You can try with as below

How to Convert Date and Time Format using UiPath || RPA UseCase

Hope this may help you

Thanks

[prasath17 (Guru)]

@MartianxSpace - Please check this post…

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…

[MartianxSpace (Chitti)]

Yet, it was so simple but I got confused .

Here is the solution, it converts the date to (System format) MM/dd/yyyy format

Convert.ToDateTime(dateSource).ToShortDateString

I don’t need the date format here because I want the bot to take the system date format
thank you @Srini84 @prasath17