Sorting date ISO

Patrik_vohzrf

Confluence 7.4.1

I have a table with a column of datetime text with varying detail in iso. For some reason the first item do not get sorted correctly, even though regardless if sorted as date or text, the correct position should be the same.

2020-10-09 08 
2020-09-10 
2020-10-06
2020-10-07
2020-10-07
2020-10-07 07:58
2020-10-07 14:55  
2020-10-07 16:03
2020-10-07 17:31
2020-10-07 23:05
2020-10-08
2020-10-08
2020-10-08 16:00 
2020-10-08 18:00 
2020-10-09 08:50
2020-10-09 9:15
2020-10-09 9:34
2020-10-09 10:38
2020-10-09 11:15

Bill Bailey

All of your dates have a space after the first hyphen/dash, except "2020-09-10".  Just do a find for "- " and replace with "-" and it will sort correctly.