How sort rows in a table, based on date

[John de Groot]

In a table I have one column that only contains a date created by "//" .

If I want to sort the table rows on the date in that column, it will sort first by day, then month, then year as the format for "//" is dd-MM-yyyy (so 2 april 2018, 3 may 2019, 4 april 2018). 

In general settings I changed the format to yyy-mm-dd, but that has no effect on the date created by "//".

How can I correctly sort the table rows on dates specified in a dedicated column ?

(or how can I adjust the date format of function "//" ?)

[Mirek]

You are facing this problem - https://jira.atlassian.com/browse/CONFSERVER-34225 unfortunately when using // it is not yet supported. You can try to add dates as normal text and then it will be sorted as expected.

[John de Groot]

Thanks for your response and suggestion (we came up with the same alternative).

... Sometimes we are surprissed by the functionallity and flexibility of Atlassian.

... Sometimes we are dissapointed by the immaturity and inflexibility of Atlassian.

[Mirek]

@John de Groot- I need to recall myself that this is not supported since I check a little deeper and this feature looks like it is actually implemented in 5.8 Confluence. However since then there is a bug :) - https://jira.atlassian.com/browse/CONFSERVER-38083 . So, you might be affected by it or do not yet have 5.8 (or higher) and have not this feature available. Anyway suggestion did not change .. it is better to keep using the alternative solution until this will not be fully fixed and working for everyone.