I sorted a dd-mm-yyyy date column but it doesn't gets sorted correctly.
This is how it looks like after sorting which is incorrect.
01-03-2018
02-02-2018
03-02-2018
03-03-2018
03-03-2018
04-03-2018
04-03-2018
04-12-2017
04-12-2017
05-03-2018
06-02-2018
06-12-2017
Any tips?
1 Answer
After selecting date and selecting sort anything that looks like a number, as a number it is sorting correctly. Earlier I was selecting sort numbers and numbers stored as text separately.
