Issue Summary

      Sorting a table column with dates won't work properly. The sort won't happen as expected. Tested using bellow date formats:

      • dd/MM/yyyy
      • dd-MM-yyyy
      • using the date macro
      • yyyy/MM/dd
      • yyyy-MM-dd

         

        Steps to Reproduce

      1. Create a Confluence page using the new editor.
      2. Insert a table.
      3. Populate a column with dates.
      4. Publish the page.
      5. Sort the table by this column.

      Expected Results

      The column should be sorted properly (increasing or decreasing the dates).

      Actual Results

      The sort is not applied correctly.

      Workaround

      Use the date picker to insert the date and this will ensure the table can be sorted correctly based on the date.

        1. image-2021-04-13-10-51-55-262.png
          58 kB
          Vishalakshi Narayana Swamy
        2. image-2021-04-13-10-52-08-129.png
          149 kB
          Vishalakshi Narayana Swamy

            [CONFCLOUD-70026] Not able to sort table column by dates

            Atlassian Update - December 20, 2024

            Hi everyone,

            Thank you for previously raising this bug and bringing it to our attention.

            Within our company roadmap and work capacity, we try to address or review each bug request but admit that not each one will be resolved. To continue the culture of being honest and open, we are closing this bug to focus on our upcoming roadmap for all Confluence users.

            As we continue to roll out features we do look at requests made by our users and if you feel like this bug is still impacting your team please let us know.

            Thank you again for providing valuable feedback to our team!

            Matthew Hunter added a comment - Atlassian Update - December 20, 2024 Hi everyone, Thank you for previously raising this bug and bringing it to our attention. Within our company roadmap and work capacity, we try to address or review each bug request but admit that not each one will be resolved. To continue the culture of being honest and open, we are closing this bug to focus on our upcoming roadmap for all Confluence users. As we continue to roll out features we do look at requests made by our users and if you feel like this bug is still impacting your team please let us know. Thank you again for providing valuable feedback to our team!

            It would be fantastic if a date column should be sorted properly (increasing or decreasing the dates).

            Laurent Ricci added a comment - It would be fantastic if a date column should be sorted properly (increasing or decreasing the dates).

            Paige added a comment -

            Sorting numerically at all does not work, no matter the date format, not using the date macro. Changing dates to 11.01.22 format doesn't even work although that should be read as a numeric decimal.

            Paige added a comment - Sorting numerically at all does not work, no matter the date format, not using the date macro. Changing dates to 11.01.22 format doesn't even work although that should be read as a numeric decimal.

            Sorting on a column of an array containing dates does not work.
            The rows are not all sorted by date.
            The problem always occurs when using the standard sort function and the one related to the Table Filters macro.

            Aroldo BUDELLI added a comment - Sorting on a column of an array containing dates does not work. The rows are not all sorted by date. The problem always occurs when using the standard sort function and the one related to the Table Filters macro.

            No updates on this issue for over 6 months?

            Terence Kent added a comment - No updates on this issue for over 6 months?

              rtekhov Roman Tekhov (Inactive)
              edc026a7b429 Vitor A (Inactive)
              Affected customers:
              5 This affects my team
              Watchers:
              13 Start watching this issue

                Created:
                Updated:
                Resolved: