Page 1 of 1

Convert Manual Date to DateTime

Posted: Fri May 20, 2016 6:09 pm
by 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

Re: Convert Manual Date to DateTime

Posted: Sat May 21, 2016 4:17 am
by 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"));

Re: Convert Manual Date to DateTime

Posted: Sat May 21, 2016 4:37 am
by Dummy1912
Thank you so much dear friend
it worked like a charm :)

+rep for sure