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

      In Confluence, changing the Formatting and International Settings Date format settings seems to make no difference on the date picker macro.

      Before changing, using the "//" command in edit mode lets me pick a date from the calendar. That date renders as dd MMM yyyy. Changing the date format in the Formatting and International Settings area as follows:

      Date Time Format yyyy-MM-dd HH:mm
      Date Format yyyy-MM-dd

      makes zero difference on the output of that control. Is there something I'm missing? Due to the way Confluence doesn't properly sort dates, this is a big deal!

            [CONFSERVER-40087] Date picker macro doesn't use specified date format

            SET Analytics Bot made changes -
            UIS Original: 3 New: 1
            SET Analytics Bot made changes -
            UIS Original: 4 New: 3
            SET Analytics Bot made changes -
            UIS Original: 6 New: 4
            SET Analytics Bot made changes -
            UIS Original: 4 New: 6

            Patrice (DEMICON) added a comment - - edited

            The documentation states

            The date format displayed will depend on the language settings of the current user, and not the global default language settings. This means the lozenge will appear differently for different users.

             

            In my opinion this doesn't always comply with how users actually work because Confluence language settings and other format should be mixable just like in other tools like MS Office for example.

            Think of my settings for example:

            • I set my user's language setting to English (US / UK) because I want to use Confluence in English
            • At the same time I am used to the German date (MM.dd.yyyy) and time (HH:mm) settings.

             

            Therefore, please discuss several ways to solve this:

            • provide a way to override the date and time format for users, e.g. a separate dropdown providing the common formats so that also newbie users understand what will be displayed
            • provide an option for administrators to force using the global date and time settings and therefore disabling the usage of users' date formats based on language settings and the potential override function

             

             

            Patrice (DEMICON) added a comment - - edited The documentation states The date format displayed will depend on the language settings of the current user, and not the global default language settings. This means the lozenge will appear differently for different users.   In my opinion this doesn't always comply with how users actually work because Confluence language settings and other format should be mixable just like in other tools like MS Office for example. Think of my settings for example: I set my user's language setting to English (US / UK) because I want to use Confluence in English At the same time I am used to the German date ( MM.dd.yyyy ) and time ( HH:mm ) settings.   Therefore, please discuss several ways to solve this: provide a way to override the date and time format for users, e.g. a separate dropdown providing the common formats so that also newbie users understand what will be displayed provide an option for administrators to force using the global date and time settings and therefore disabling the usage of users' date formats based on language settings and the potential override function    
            SET Analytics Bot made changes -
            UIS Original: 6 New: 4
            SET Analytics Bot made changes -
            UIS Original: 4 New: 6

            Isabelle Boshoff added a comment - https://confluence.atlassian.com/doc/configuring-time-and-date-formats-150144.html  
            Isabelle Boshoff made changes -
            Comment [ !image-2024-10-01-09-08-34-137.png! ]
            SET Analytics Bot made changes -
            UIS Original: 6 New: 4

              Unassigned Unassigned
              db0701fd7070 Ari Brown
              Affected customers:
              60 This affects my team
              Watchers:
              45 Start watching this issue

                Created:
                Updated: