Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-70026

Not able to sort table column by dates

XMLWordPrintable

      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

              rtekhov Roman Tekhov (Inactive)
              edc026a7b429 Vitor A (Inactive)
              Votes:
              5 Vote for this issue
              Watchers:
              13 Start watching this issue

                Created:
                Updated:
                Resolved: