Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

The recommended recommended date format type to use for date sorting dates is the M column type. The support for M type date sorting support is sorting is built-in including multiple language support and does not require any additional server installation.

Tip
titleHow to know if the M column type is available on in my Confluence instance

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. See Column types for more information.


Info
titleAcknowledgement

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.

...

Csv
ISO-8601 Format
YYYY-MM-DD
YYYY-MM-DDTHH
YYYY-MM-DD HH
YYYY-MM-DDTHH:mm
YYYY-MM-DD HH:mm
YYYY-MM-DDTHH:mm:ss
YYYY-MM-DD HH:mm:ss
YYYY-MM-DDTHH:mm:ss.SSS
YYYY-MM-DD HH:mm:ss.SSS
YYYY-MM-DDTHH:mm:ss Z
YYYY-MM-DD HH:mm:ss Z

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.

...