[Solved] ORDER BY Date descending in MySQL is not working in VB.Net

Dear Sir/Maam,

I have a problem for sorting my data in the datagrid by date from new to old

It supposedly the latest is 04/02/2024 which is february and its not january 28 2024

    Sub pop_updatedlearnersinformation()
        Try
            dcom = New MySqlCommand
            Dim dset As New DataSet

            dcom.Connection = ultracon

            da = New MySqlDataAdapter("Select * from tblupdatedstudentinformation ORDER BY DateUpdate DESC", ultracon)
            da.Fill(dset, "tblupdatedstudentinformation")
            dgvUpdatedLearner.DataSource = dset.Tables("tblupdatedstudentinformation").DefaultView
            lblCounter.Text = dset.Tables("tblupdatedstudentinformation").Rows.Count & " " & "Record(s) Found"

i also tried this method and its not working

dgvUpdatedLearner.Sort(dgvUpdatedLearner.Columns(1), System.ComponentModel.ListSortDirection.Descending)

appreciate your help

Thank you and best regards