Breadcrumbs

[Dummy1912]

Hello,

Can anybody help me please
can't find it on google

i have in my db custom date like

Code: Select all

May22016
May122016
Jan252016

how can i convert this to a datetime?

tried:

Code: Select all

Dim myDateTime As DateTime = DateTime.Parse("May22016")
myDateTime.ToString("MMM d, yyyy ddd") 'want to show it like May 2, 2016 Mon

but got error :(

please anyone...

Thanks

[SumCode]

You can try using Regex:

Code: Select all

var sDate = "May22016";
var fDate = Regex.Replace(sDate, @"^(\w{3})(\d{1,2})(\d{4})$", "$1/$2/$3", RegexOptions.Multiline); //Formats date
var dt = DateTime.ParseExact(fDate, "MMM/d/yyyy", new CultureInfo("en-US"));
Console.WriteLine(dt.ToString("MMM d, yyyy ddd"));

[Dummy1912]

Thank you so much dear friend
it worked like a charm

+rep for sure