Ordering by Date

This is problem a dumb question and I'm probably missing something obvious, but why is it when I order a query by date, it puts dates such as 01/03/23 lower in the ascending list then it does 01/30/23? Everything from the 10th of the month on is fine.

Can you paste the result and the query?
You can also add in the query at the end ORDER BY date ASC or ORDER BY date DESC

Agreed, it would be helpful to see the data! If it's a SQL query, it would also be helpful to see the column type for the date data.

For example, I can see that id is an integer, so it should be sorted as such