VB.NET: Format Date......[Resolved]

[toytoy]

Say i have these XML tag

<book published="New York">
    <date day="12" month="1" year="2005" />    
</book>

How do i exactly format the date since i am getting three different attributes (day, month and year) from the server......

Say i want the format to be "DD/MM/YYYY"...

I want the format date to be displayed in the listbox...

Does anyone have any idea to combined all three attributes and format instead of format directly the date as a whole....

Thanks

[nemaroller]

I believe your intention is to format the date your given for display in a listbox, correct?

Then you would probably want to implement a variation of the date formatting options available.

Dim day As String = "2"
 Dim month As String = "9"
 Dim year As String = "2002"
 
 Dim tempDt As DateTime = New DateTime(Integer.Parse(year, CultureInfo.InvariantCulture), _
           Integer.Parse(month, CultureInfo.InvariantCulture), Integer.Parse(day, CultureInfo.InvariantCulture))
 MessageBox.Show(String.Format("{0}", tempDt.ToString("dd/MM/yyyy")))

[toytoy]

where you got the CultureInfo....

I got error saying it is not declared..

[mendhak]

What's wrong with simply using Date.Parse?

[nemaroller]

You need to include an imports statement at the top of the class.

Imports System.Globalization

[nemaroller]

What's wrong with simply using Date.Parse?

There are apparently some logic holes in Date.Parse and we've been receiving about a dozen errors now and then on valid dates. We don't know for sure what's causing the errors, but constructing the Date object with integer values solved it. My guess is some users even in the US do not use the default US-EN culture format (immigrants?) on their systems.

[mendhak]

Very interesting, this is making me think about all the places I have used it.

It just goes to show that everyone should adopt the US date format or be annhilated.

[toytoy]

I use these few lines to solve it...

Dim niEuro As New System.Globalization.DateTimeFormatInfo
Dim dd, mm, yyyy, pa As String
 
dd = nod2.Attributes("day").Value
mm = nod2.Attributes("month").Value
yyyy = nod2.Attributes("year").Value
pa = dd & "/" & mm & "/" & yyyy
niEuro.ShortDatePattern = "dd/MM/yyyy"
Dim dataEuro As Date = Date.Parse(pa, niEuro)
MessageBox.Show(dataEuro)

but nemaroller, your solution is still the best..