UK Dates not sorting correctly!

Hi Jean Pierre,

In this instance no, I imported a CSV file that was exported from sheets.

I have yet to try copy-paste from a Google sheet in the browser.

I updated to say that I found changing the column type from it’s original Text to Date did not work and I had to edit each cell to get a ‘true’ date, then it sorted correctly.

It would be good to understand, rather than trial and error, which are the preferred use cases for each data type. If this is known then a chart of import method vs expected results would be useful, especially for new users.

Many thanks.

1 Like