Difficulty with formatting a string to parse to date in vb.net

Question

dim dt as string= "03/22/20 20:12:27.320"

Dim tempDate As DateTime = DateTime.ParseExact(dt, "MM/dd/yy hh:mm:ss.fff", CultureInfo.GetCultureInfo("en-US").DateTimeFormat)

This gives error sometimes : System.FormatException: 'String was not recognized as a valid DateTime.'

Why? It seems to be formatted properly. VB.net 4.6.1 framework

jmcilhinney · Accepted Answer · 2020-03-26 02:54:27Z

1

"hh" is 12-hour format. 20 is obviously not a valid hour in 12-hour format. If you want 24-hour format then use "HH".

answered Mar 26, 2020 at 2:54

jmcilhinney

54.9k5 gold badges30 silver badges52 bronze badges

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

Comments

gilbertdim · Accepted Answer · 2020-03-26 02:43:50Z

0

Have you tried to use CDate() function?

dim dt as string= "03/22/20 20:12:27.320"
dim tempDate as Datetime = Cdate(dt)

or

dim tempDate as Datetime = Cdate("03/22/20 20:12:27.320")

answered Mar 26, 2020 at 2:43

gilbertdim

3573 silver badges12 bronze badges

1 Comment

jmcilhinney Over a year ago

That would only work when the system culture is set to US. Everywhere else places the day before the month and so the use of CDate would only work correctly for 12 days of the year. The rest of the time it would either fail or, even worse, succeed but produce the wrong value.

Collectives™ on Stack Overflow

Difficulty with formatting a string to parse to date in vb.net

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related