Using a column with date, format dd/mm/yyyy (UK) and the table sort on this is incorrect.
Guidance or fix needed, please.
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.