Uploaded image for project: 'Confluence Data Center'
  1. Confluence 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

          causes

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-74697 Tables date label columns with empty cells cannot be sorted properly

          • Low - Low priority issues
          • Closed

          PSR-702 Loading...

          is cloned from

          Suggestion - CONFSERVER-34002 Dates aren't sorted correctly

          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-58581 Sorting a column with dates on the Page Property Report macro does not work correctly in some language settings

          • Low - Low priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-60052 Sorting Dates in order in a table does not works when Profile language is set to Deutsch (Deutschland)

          • Low - Low priority issues
          • Closed
          is related to

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

          • Medium - Medium priority issues
          • Closed
          relates to

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

          • Medium - Medium priority issues
          • Closed

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

          • Low - Low priority issues
          • Closed

          Suggestion - CONFSERVER-34002 Dates aren't sorted correctly

          • Closed

          Suggestion - CONFSERVER-35168 Date Lozenge Date Format and Sorting

          • Gathering Interest

          Suggestion - CONFSERVER-55188 Make the date format for the date picker "//" shortcut configurable

          • Gathering Interest

          PSR-662 Loading...

          mentioned in

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: