Overview
Starting with version 6.4 of the Advanced Tables for Confluence app, it It is possible to specify the format that is used to view date columns. The Note that the actual data is not changed, just how it is displayed varies. This helps keep the data looking consistent even if the provided data is not. This can be enabled by using the Date (M)column type for the Column types parameter corresponding to the column. Advanced date sorting specifies how to use the Date (M)Date column type to customize the column data interpretation as a date.
...
- Input format - this is the first format specified on the Date (M) column type, although it is defaulted when nothing is specified. See Advanced date sorting for more details.
- Display format - this is how you want the date to be displayed and sorted. If it is not specified, the column displays is displayed as-is. The display format is similar but a bit more complex than the input format. It is summarized in the succeeding sections. The ~ character is used to separated the input and display formats to avoid most conflicts with characters used in formats.
...
| Info | ||
|---|---|---|
| ||
Advanced date sorting support with the Date (M) column Date 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. |
| Table plus | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
...