Sorting by Date column not in order

I have a query that I wanted to sort the results by date, but oddly, the results sort out of order. Does anyone know why this is and/or how to fix it?

Screenshot 2024-09-12 at 10.40.00 AM

They are most probably sorted alphabetically, so e.g. 6 is counted as greater than 11, just because “6” is greater than “1”. To sort by the implied date, should use an advanced query.