converting "123105" to a date..

[VladimirKim]

Hi.
Is there a function in VB.NET to convert a string, let's say "123105", to a date "12/31/05"?
Thanks.

 

[TipGiver]

Use the .insert of the string and add two "/".

dim strDate as string = "123105"
strDate = strDate.Insert( ... ).insert( ... )

Use two inserts like the example of the two "/"

Then : dim tDate as date = CDate(strDate)

 

[TipGiver]

Dim strDate As String = "311205"
strDate = strDate.Insert(2, "/").Insert(5, "/")
Dim tDate As Date = CDate(strDate)
MsgBox(tDate)

Notice that i changed "123105" to "311205" because there will be an exception. The reason: 12=day, 31=month??, 05=year. For you it will be ok.

So you have before converting it to date to apply to the string a format like: "mm/dd/yy" for example


Hope these help

 

[ThatRickGuy]

Un tested, but if you do as TG mentioned, and change it to MMddyy you could try this:

?cdate(cint("123105").tostring("##/##/##"))

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[SBendBuckeye]

I think CDate("123105").ToString also works.

Have a great day!

j2consulting@yahoo.com

 

[earthandfire]

A slight modification/extension to Rick's solution:

CDate(CInt("123105").ToString("##/##/##")).ToString("MM/dd/yy")

Hope this helps.

 

[ThatRickGuy]

Or to use region settings:

CDate(CInt("123105").ToString("##/##/##")).ToShortDate

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[MickTheBelgian]

This should also be possible with Date.ParseExact , No?

 

[VladimirKim]

Thanks a lot to all of you. that's exactly what i needed.
Vladimir