Change array date format

Question

The date that scan from word document which is 30/08/2012 but when it loads into my program it prints 20/10/05. Below code have error for convert it.

Dim str() As String

str(1) = Convert.ToDateTime(Format("yy-MM-dd")) Any suggestion?

AKZap · Accepted Answer · 2013-07-02 03:52:22Z

1

Try this code

Dim output As Date = Date.ParseExact(str(1), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture)

answered Jul 2, 2013 at 3:52

AKZap

1,2116 gold badges18 silver badges31 bronze badges

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

3 Comments

Brownie yeo Over a year ago

Error String was not recognized as a valid DateTime.

Antonio Over a year ago

If str(1) value is 30/08/2012 is must recognize it. The first parameter must be the date string. Maybe it has more invalid characters: you have to get only the date string first.

Brownie yeo Over a year ago

i make a breakpoint.the str value is 30/08/2012.but i dunno why it execute become 20/10/05.

Collectives™ on Stack Overflow

Change array date format

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related