如何在html中按date dd-mm-yyyy格式对数据表进行排序？

<th onclick="sortTableByDate()">Date</th>

function sortTableByDate() {
  var table = document.getElementById("myTable"); // 替换为你的表格ID
  var rows = table.rows;
  var columnIndex = 0; // 替换为日期所在列的索引

  var dates = [];
  for (var i = 1; i < rows.length; i++) {
    var date = rows[i].cells[columnIndex].innerHTML;
    var parts = date.match(/(\d+)/g);
    var day = parts[0];
    var month = parts[1];
    var year = parts[2];
    var formattedDate = year + "-" + month + "-" + day; // 转换为yyyy-mm-dd格式
    dates.push(formattedDate);
  }

  dates.sort(function(a, b) {
    return new Date(a) - new Date(b);
  });

  for (var i = 0; i < dates.length; i++) {
    var sortedIndex = dates.indexOf(rows[i + 1].cells[columnIndex].innerHTML);
    table.appendChild(rows[sortedIndex + 1]);
  }
}