Convert String to DateTime in VB

Question

How to convert following String to DateTime in VB?
I got error when executing code as below:

Dim date As String = "Wed Mar 30 2016 00:00:00 GMT+0800 (Malay Peninsula Standard Time)"
DateTime.Parse(date)

System.FormatException: "String was not recognized as a valid DateTime."

Have you checked this answer : stackoverflow.com/questions/12675421/… ? as suggested, can you directly pass the timestamp ? — Martin Verjans
– Martin Verjans, Commented Apr 18, 2016 at 12:31

Soner Gönül · Accepted Answer · 2016-04-18 12:30:01Z

3

Your string is clearly not a standard date and time format for any culture.

But since your string has UTC Offset, I would parse it to DateTimeOffset instead. And since it does not keep timezone name and it's abbreviations, you need to escape them as a string literal delimiter. You can use ddd MMM dd yyyy HH:mm:ss 'GMT'zzz '(Malay Peninsula Standard Time)' format for that.

C#

var date = "Wed Mar 30 2016 00:00:00 GMT+0800 (Malay Peninsula Standard Time)";
var dto = DateTimeOffset.ParseExact(date, 
              "ddd MMM dd yyyy HH:mm:ss 'GMT'zzz '(Malay Peninsula Standard Time)'",
              CultureInfo.InvariantCulture);

VB.NET

Dim [date] = "Wed Mar 30 2016 00:00:00 GMT+0800 (Malay Peninsula Standard Time)"
Dim dto = DateTimeOffset.ParseExact([date], "ddd MMM dd yyyy HH:mm:ss 'GMT'zzz '(Malay Peninsula Standard Time)'", CultureInfo.InvariantCulture)

Now you have a DateTimeOffset as {30.03.2016 00:00:00 +08:00}. Now you can use it's .DateTime ot .UtcDateTime properties as you want.

edited Apr 18, 2016 at 12:30

answered Apr 18, 2016 at 12:24

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Soner Gönül Over a year ago

Ups, c# tag removed. Since I'm not familiar with vb.net syntax, I converted this code to vb.net with converter.telerik.com

Collectives™ on Stack Overflow

Convert String to DateTime in VB

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related