Date time order in listview not working correctly

Hi,

Whenever I am trying to order cases by date it doesn’t see the date numbers as a date but just as a string of numbers and then it doesn’t order it correctly.
My format is as follows; DD-MM-YY. The following happends when I order by date, from newest to oldest;
I have several dates;
01-09-2016
02-09-2016
02-08-2016
03-08-2016
05-08-2016
05-07-2016

When I order this, it comes out as follows:
01-09-2016
02-08-2016
02-09-2016
03-08-2016
05-07-2016
05-08-2016

So instead of understanding which is the older or newer date it just checks the lowest or highest number. so when the day is the same it will check the next number, but thats a different month. Now I can ofcourse change the format to YY/MM/DD, but thats not what anybody want, it’s just not how we read dates anywhere.
What could be the problem here, or the solution ofcourse.

Thanks in advance.

the field type is a datetime type.

Something went wrong with importing, he mixed the days and dates.

So it’s “solved”.

thanks