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:
- Allow Confluence admins to specify the date format the Date Lozenge and allow users to enter the date as mm-dd-yyyy.
- 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.