Uploaded image for project: 'Confluence Server and Data Center'
  1. Confluence Server and Data Center
  2. CONFSERVER-38083

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

    XMLWordPrintable

Details

    Description

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? 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 6.15.6

      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 f0S76Dx2jG.gif

      Notes

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

      Date sorting feature doesn't sort plain text dates since plain text dates could be ambiguous to users with different system & profile locales.   

      Attachments

        1. f0S76Dx2jG.gif
          f0S76Dx2jG.gif
          743 kB
        2. image-2017-11-30-09-59-20-565.png
          image-2017-11-30-09-59-20-565.png
          8 kB
        3. macrosettings.png
          macrosettings.png
          65 kB
        4. sorterror1.png
          sorterror1.png
          20 kB
        5. sorterror2.png
          sorterror2.png
          25 kB

        Issue Links

          Activity

            People

              zxu2@atlassian.com Zac Xu
              1742255c744c Alexander Schätzle
              Votes:
              159 Vote for this issue
              Watchers:
              116 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: