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;
When I order this, it comes out as follows:
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.