Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

On this page


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 macro and find the Column types parameter. If M is listed in the help text, then it is available for use.


Advanced date sorting support with the M column type is provided using Javascript implemented by the Table Library for Bob Swift Apps with the help of the Moment.js library (open source, MIT license). A summary of the relevant parts of the moment.js documentation is repeated here.

Automatic support

On specifying just the M column type, default date parsing recognizes a number of common date formats including those recognized by the browser specific Javascript implementation. However, there can be browser specific inconsistencies. The following ISO-8601 formats are recognized consistently across browsers:

User specified formats

On 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

Non-alphanumeric characters are ignored, so, for this example, both of the following are treated the same with the MM-DD-YYYY format:


Similarly, formats can be specified with or with non-alphanumeric separators. However, using separators helps with readability.

Format tokens 

See the Moment.js documentation for further information.

M, MMMonth Number (1 - 12)
MMM, MMMMMonth Name (In current language)
D, DDDay of month
DDD, DDDDDay of year
d, dd, ddd, ddddDay 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)
YY2 digit year (if greater than 68 will return 1900's, otherwise 2000's)
YYYY4 digit year
H, HH24 hour time
h, hh12 hour time (use in conjunction with a or A)
m, mmMinutes
s, ssSeconds
SDeciseconds (1/10th of a second)
SSCentiseconds (1/100th of a second)
SSSMilliseconds (1/1000th of a second)
Z, ZZTimezone offset as +07:00 or +0700
XUnix timestamp

Language support (i18n)

When the date format contains any other language words, the appropriate language must 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.


M(de)YYYY-MMM-DD for a German date like: 2013-Mrz-10 

M(fr) for a French date like Janv 10, 2013

Supported languages

Click the link, in the following list of languages supported by the Moment.js library, to get the details of the specific localization:

  • No labels