Date format listviewitem

Question

How to perform date formatting in the listview item text property? It is currently displaying #2011/08/08# and I want to convert it to "mm-dd-yyyy".
Please help!

Vulpes · Accepted Answer

You can do the conversion with code such as this:
Dim str As String = "#2011/08/08#" str = DateTime.Parse(str.Trim("#"c)).ToString("MM-dd-yyyy")
However, if you're using databinding, it might be easier to format the date before binding takes place.

Vulpes · Answer

That line doesn't need to be altered. So your code should now be:
ConvertDateTime(stDate, eDate) ' fills stDate and eDate strTempArray(7) = translate("CYCLE TIME:  ") & stDate.ToShortDateString & " -- " & eDate.ToShortDateString

latika singh · Answer

Converted line: strTempArray(7) = translate("CYCLE TIME:  ") & stDate.ToShortDateString & " -- " & eDate.ToShortDateString
to strTempArray(7) = translate("CYCLE TIME:  ") & Me.ConvertDateTime(stDate, eDate)
Says, expression does not produce a value.

Vulpes · Answer

One way of doing it would be to pass those variables by reference:
Private Sub ConvertDateTime(ByRef stDate As String, ByRef eDate As String)    stDate = CDate(ListView1.Items(0).Text).ToShortDateString    eDate = CDate(ListView1.Items(ListView1.Items.Count - 1).Text).ToShortDateString End Sub
You can then call the method with:
ConvertDateTime(stDate, eDate)
and the variables will now contain the converted strings when the method returns.

latika singh · Answer

Private Sub ConvertDateTime()
stDate = CDate(ListView1.Items(0).Text).ToShortDateString
eDate = CDate(ListView1.Items(ListView1.Items.Count - 1).Text).ToShortDateString
End Sub
The two variables above, I want to pass them to another sub inside line:
strTempArray(7) = translate("CYCLE TIME:  ") & stDate.ToShortDateString & " -- " & eDate.ToShortDateString
Currently I am ignoring the ConvertDateTime() and declaring the above variables locally in another sub to store in the strTempArray(7) variable.
Is it possible to do it by creating a subroutine that separately stores Listview item string and then pass these variables the way it is now in the temp array variable?

Vulpes · Answer

Not sure what you're asking but, if you're wanting to populate a string array with 3 three strings, then the syntax will be:
Dim TempArray() As String = {translate("Cycle Time"), stDate.ToShortDateString, eDate.ToShortDateString}
You can then print the array with code such as this:
Dim Combined As String = String.Join(", ", TempArray)   MessageBox.Show(Combined)

latika singh · Answer

I created a sub and converting the Text string from Listview item using "CDate".
But now i need to use these variables stDate and eDate into another sub to print Cycle Time. Check the line below:
TempArray() = translate ("Cycle Time") & stDate.ToshortDateString & eDate.ToShortDateString.
This line is in another sub. I need to pass the above two variables in this line.