Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-35168

Date Lozenge Date Format and Sorting

XMLWordPrintable

    • 2
    • 0
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? 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:
              87 Vote for this issue
              Watchers:
              64 Start watching this issue

                Created:
                Updated: