On plugin versions 6.x and higher, advanced date sorting for a column is available by specifying the M column type. An older alternative is available for all plugin versions, but more specifically 5.x and lower, see How to add advanced date sorting using the D column type. The support for M type date sorting support is built in including multiple language support and does not require any additional server installation - this is the recommended type to use for date sorting.
How to know if the M column type is available on my Confluence
In the Macro Browser, search for the Table Plus and find the Column types parameter. If M is listed in the help text, then it is available for use.
By specifying a format string following the M column type, a specific date format can be handled. Construct the date format string from the set of format tokens.
Non-alphanumeric characters are ignored, so, for example, both of the following will be treated the same using format: MM-DD-YYYY:
Similarly, formats can be specified with or with non-alphanumeric separators. However, using separators helps with readability.
See the Moment.js documentation for further information.
|M, MM||Month Number (1 - 12)|
|MMM, MMMM||Month Name (In current language)|
|D, DD||Day of month|
|DDD, DDDD||Day of year|
|d, dd, ddd, dddd||Day of week (NOTE: the input for these tokens is ignored, as there are 4-5 weeks in a month, and it would be impossible to get the day of the month based off the day of the week)|
|YY||2 digit year (if greater than 68 will return 1900's, otherwise 2000's)|
|YYYY||4 digit year|
|H, HH||24 hour time|
|h, hh||12 hour time (use in conjunction with a or A)|
|S||Deciseconds (1/10th of a second)|
|SS||Centiseconds (1/100th of a second)|
|SSS||Milliseconds (1/1000th of a second)|
|Z, ZZ||Timezone offset as |
When date format contain national language words, the appropriate language needs to be indicated. English (US) is the default if nothing is specified. The language is specified by following the M with (lang indicator) prior to the format string.
Example: M(de)YYYY-MMM-DD for a German date like: 2013-Mrz-10
Example: M(fr) for a French date like Janv 10, 2013
The following is a list of languages supported by the Moment.js library. Click on the link to get the details of the specific localization.