How to convert string to date format("dd/MM/yyyy")

[vickydas (vicky)]

Hello @roysupriya21

@roysupriya21

i have a string var where i have stored one date . it is coming from pdf . But problem is in some output i am getting 20/3/2019 and some other output i am getting 203/2019 or sometime getting 2032019 . thats why i want that string as a date so that i can always get the proper date format .

A simple solution to this problem would be to create an Array of string Datatype variable and store all the available datetime format in your case

Arr_of_String_ = {"dd/MM/yyyy","ddM/yyyy"}

than use this code to get the desired date in string

DateTime.ParseExact(DateinStringvariable,Arr_of_strrr,Globalization.CultureInfo.CurrentUICulture.DateTimeFormat,nothing).ToString("dd-MM-yyyy")

Check this workflow and post for better understanding

Multiple Date formats.xaml (4.8 KB)

Converting String to Date w/ Multiple Formats

Yeah, if you use ParseExact(). It won’t with just .Parse though. You’re right. You can simply just place that array in the ParseExact, without needing .TryParseExact. arrFormats = {"MM/dd/yyyy","MM/d/yyyy","M/dd/yyyy","M/d/yyyy"} datevalue = DateTime.ParseExact(closeDate, arrFormats, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat) Should probably still use .TryParseExact though before to make sure it’s a date format. arrFormats = {"MM/dd/yyyy","MM/d/yyyy","M/dd/yyyy","M/d/y…