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?

10

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.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy