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

Date Lozenge Date Format and Sorting

XMLWordPrintable

    • 2
    • 4
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

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

      It would be incredibly useful if the date format of the Date Lozenge could be customized. Currently, it looks like the only way to display the date is the dd-mm-yyyy format. This causes problems when attempting to sort Date Lozenges that display in either a table or in a Page Properties Report macro. It sorts the day then the month then the year. Thus we end up with:

      16 Sept 2014
      17 Aug 2014
      18 January 2013

      I realize most of the world does put dates in the logical order (dd-mm-yyyy), but the US is behind on this unique concept, so I often have people asking me if the date can be changed or if they can put the date in as mm-dd-yyyy instead.

      I see two ways of fixing this:

      1. Allow Confluence admins to specify the date format the Date Lozenge and allow users to enter the date as mm-dd-yyyy.
      2. Correct the sorting of the Date Lozenge in the dd-mm-yyyy format so it sorts correctly by Year, Month, then Day in tables and the Page Properties Macro.

              Unassigned Unassigned
              mark.collett MarkC
              Votes:
              65 Vote for this issue
              Watchers:
              44 Start watching this issue

                Created:
                Updated: