UK Dates not sorting correctly!

1

Hi,

Using a column with date, format dd/mm/yyyy (UK) and the table sort on this is incorrect.
Guidance or fix needed, please.

UPDATE

I have resolve this. I had imported CSV data and the doc had applied a text value. When I changed the column type to date format I had to edit each cell to ‘fix’ the format.

This does raise a question though. If you import from CSV how to you get the column types set? In my case I only had about 15 rows, but if you had many more this would not be good.

2

Hi,

Have you tried to copy paste from Excel to CODA straight away

3

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