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

      Summary

      Page properties report macro is not sorting DD/MM/YYYY in the proper order; that is, going by month year first, then month, then day. Instead, it is sorting in alpha-numeric order.

      Environment

      • Confluence
      • Page Properties Macros 4.3.1

      Steps to Reproduce

      1. Create a few pages with a table including a date in one column with typing //
      2. Add a common label to those pages.
      3. Create a new page with Page Properties Report Macro and include the date column

      Expected Results

      • With date format MM/DD/YYYY attempt to sort; should sort in logical order.

      Actual Results

      • In some cases, will sort alpha-numeric order instead.
      • In the original example, it was the simple DD MMM YYYY, however, I have also seen the issue only when switching browser language to German and allowing confluence to switch to German

        1. date_sort.png
          date_sort.png
          3 kB
        2. Testtable-sorted-german-user-profile.png
          Testtable-sorted-german-user-profile.png
          48 kB
        3. Testtable-sorted-english-user-profile.png
          Testtable-sorted-english-user-profile.png
          44 kB
        4. Macro_settings_Sort_column.png
          Macro_settings_Sort_column.png
          3 kB
        5. sorted_dates_wrong.png
          sorted_dates_wrong.png
          23 kB
        6. Sorting_by_arrows_ok.png
          Sorting_by_arrows_ok.png
          20 kB
        7. string_dates_dont_sort.png
          string_dates_dont_sort.png
          7 kB
        8. Sorting_work_around.png
          Sorting_work_around.png
          23 kB
        9. My_page_properties.png
          My_page_properties.png
          19 kB
        10. my_page_properties_report.png
          my_page_properties_report.png
          7 kB
        11. screenshot-1.png
          screenshot-1.png
          3 kB
        12. ConfDates.JPG
          ConfDates.JPG
          12 kB
        13. screenshot-2.png
          screenshot-2.png
          22 kB
        14. image-2016-10-11-10-01-08-126.png
          image-2016-10-11-10-01-08-126.png
          7 kB
        15. image-2016-10-11-10-01-43-148.png
          image-2016-10-11-10-01-43-148.png
          25 kB
        16. image-2016-10-11-10-02-21-596.png
          image-2016-10-11-10-02-21-596.png
          30 kB

            [CONFCLOUD-33566] Page properties report doesn't sort by date properly

            How is this resolved? You didn't answer Scott Stephens or Aaron Newton. We still have issues with dates not sorting correctly 

            Trevor Foley added a comment - How is this resolved? You didn't answer Scott Stephens or Aaron Newton. We still have issues with dates not sorting correctly 

            Yes how can we configure the date format when using the // to call the insert.  

            Scott Stephens added a comment - Yes how can we configure the date format when using the // to call the insert.  

            Forgive me if this is covered elsewhere (I tried to search for the answer here), but how can one specify the format for the date macro? Mine are showing up as:

             

            But my preferences in Confluence are 

             

            and

            Mostly it's annoying when creating a date, as in the US we type in MM/DD/YYYY, and the // widget wants you to type in //DD/MM/YYYY and so it's easy to produce an error.

            Aaron Newton added a comment - Forgive me if this is covered elsewhere (I tried to search for the answer here), but how can one specify the format for the date macro? Mine are showing up as:   But my preferences in Confluence are    and Mostly it's annoying when creating a date, as in the US we type in MM/DD/YYYY, and the // widget wants you to type in //DD/MM/YYYY and so it's easy to produce an error.

            No! I went into the "insert more content" menu looking for some sort of date type but couldn't find one. Didn't know about //. Thanks! Might consider adding that somewhere in the editor's UI (even if it's in a menu or something).

            Aaron Newton added a comment - No! I went into the "insert more content" menu looking for some sort of date type but couldn't find one. Didn't know about //. Thanks! Might consider adding that somewhere in the editor's UI (even if it's in a menu or something).

            @aaron newton did you use // to enter the date? If you do so the chosen date should be displayed with grey background like https://jira.atlassian.com/secure/attachment/116204/116204_date_sort.png
            Seems as if your date is entered as a string without //?
            If it is a string it is correctly sorted
            02..
            04... and so on.

            Florian Schießl added a comment - @aaron newton did you use // to enter the date? If you do so the chosen date should be displayed with grey background like https://jira.atlassian.com/secure/attachment/116204/116204_date_sort.png Seems as if your date is entered as a string without //? If it is a string it is correctly sorted 02.. 04... and so on.

            Cloud does not appear to have the fix.

            Aaron Newton added a comment - Cloud does not appear to have the fix.

            Cloud should already get the fix

            Nguyen Dang added a comment - Cloud should already get the fix

            Hi,

            Thank you so much for looking into this!
            Is there an ETA for the Cloudfix release?

            Kind regards

            Roman Verraest added a comment - Hi, Thank you so much for looking into this! Is there an ETA for the Cloudfix release? Kind regards

            This issue has been resolved in Confluence 5.10.4 which is now available for download.

            Denise Unterwurzacher [Atlassian] (Inactive) added a comment - This issue has been resolved in Confluence 5.10.4 which is now available for download .

            Chris Held added a comment -

            Fantastic! Seems to work on our test environment. Great job!

            Chris Held added a comment - Fantastic! Seems to work on our test environment. Great job!

              ndang Nguyen Dang
              18c18c0fff23 boleary
              Affected customers:
              51 This affects my team
              Watchers:
              47 Start watching this issue

                Created:
                Updated:
                Resolved: