Change DateTime Format from Various Inputs

[sidb (Alex)]

Hello everyone

I’d like to change the datetime format of a given string to MM/dd/yyyy. However, the input string can have various formats (yyyy-dd-mm, MM/dd/yy, etc.) Is there an easy way to accomplish this, not knowing the format of the input string?

[Gokul001 (Gokul Balaji)]

Hi @sidb

You can try with this expression

DateTime.ParseExact(YourString,{"yyyy-dd-MM","MM/dd/yy","MM/dd-yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM/dd/yyyy")

Regards
Gokul

[Gokul001 (Gokul Balaji)]

You can update Date format here

@Gokul001

{"yyyy-dd-MM","MM/dd/yy","MM/dd-yyyy"}

In the expression @sidb

Output