Hi im having a problem on displaying my Date ng my listview
here is my code

Private Sub frmTransaction_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Try
            IsConnected("Select CONCAT(person.lastName, ',',person.firstName,' ',person.middleName) AS FullName, transaction.transactionDate from transaction INNER JOIN person ON person.personId = transaction.personId", False)
            Call Loader()
        Catch ex As MySqlException
            MsgBox(ex.Message)
        End Try
    End Sub

this is my code to display my items on list view

Private Sub Loader()

        LV.Items.Clear()
        While (myDR.Read())
            With LV.Items.Add(myDR("FullName"))
                 .SubItems.Add(myDR("transactionDate")) '<----- ERROR!

            End With
        End While
    End Sub

im having a problem to display my date.. can anyone fix my code?

Would you be so kind as to tell us the exact error message?