Resolved What is wrong with the following DateTime.ParseExact?

[zhuanyi]

Hi,

I have a text string like this which I will need to parse:

FriMar1200:00:00EST2010

And I used the following code:

Date.ParseExact("FriMar1200:00:00EST2010", "dddMMMddHH:mm:sszzzyyyy", Nothing)

And it is giving me a A first chance exception of type 'System.FormatException' occurred in mscorlib.dll error.

Please help!

Thanks!

 

[zhuanyi]

Never mind, got it, basically you need to format EST to some time zone offset...

 

[MattP]

The problem is with the time zone abbreviation. You need to replace that with an offset time.

        Dim theDate As String = "FriMar1200:00:00EST2010"
        Dim format As String = "dddMMMddHH:mm:sszzzyyyy"
        Dim provider As CultureInfo = CultureInfo.InvariantCulture
        Dim result As DateTime
        DateTime.TryParseExact(theDate.Replace("EST", "+11:00"), format, provider, DateTimeStyles.None, result)

Edit: Looks like you found the solution while I was typing up the example.

Here's a list of time zone abbreviations and their offsets to help you out in any case. Time zone abbreviations