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

Dates aren't sorted correctly in European time format (dd.mm.yyyy)

    XMLWordPrintable

Details

    Description

      NOTE: This bug report is for Confluence Cloud. Using Confluence Server? See the corresponding bug report.

      Summary

      Dates are not sorted correctly when user is on European browser (such as Deutsch)

      Environment

      Tested in:

      • Confluence server 5.9.1
      • Cloud Confluence version 1000.150.0

      Steps to Reproduce

      1. Make sure that browser is on English language
      2. Create a page with random dates in a table
      3. Save, and try to sort it
      4. Tables are sorted correctly
      5. Go to user profile > setting > edit > set language as Deutsch
      6. Go back to the page > try to sort the dates

      Expected Results

      Dates are sorted correctly

      Actual Results

      Dates are not sorted correctly. In fact, it's sorted in a random way. see GIF attached

      Notes

      This issue is different than CONF-34002 since CONF-34002 is an improvement request for dates to be able to be sorted

      Attachments

        1. f0S76Dx2jG.gif
          f0S76Dx2jG.gif
          743 kB
        2. macrosettings.png
          macrosettings.png
          65 kB
        3. sorterror1.png
          sorterror1.png
          20 kB
        4. sorterror2.png
          sorterror2.png
          25 kB

        Issue Links

          is cloned from

          Suggestion - CONFCLOUD-34002 Dates aren't sorted correctly

          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CONFCLOUD-34545 Error in table column when sorting dates

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-38083 Dates aren't sorted correctly in European time format (dd.mm.yyyy)

          • Low - Low priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. I18N-2879 Sorting date within table is wrong when the page is created using a Non-English locale browser

          • Low - Low priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONFCLOUD-33566 Page properties report doesn't sort by date properly

          • Medium - Medium priority issues
          • Closed

          Suggestion - CONFCLOUD-34002 Dates aren't sorted correctly

          • Closed

          Activity

            People

              Unassigned Unassigned
              1742255c744c Alexander Schätzle
              Votes:
              44 Vote for this issue
              Watchers:
              35 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: