Sorting date ISO

Patrik October 13, 2020

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

1 answer

0 votes
Bill Bailey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 13, 2020

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events