| Div | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
Overview
Starting with Version 6.4 of the Advanced Tables for Confluence add-on, it is possible to You can specify the format that is used to view date columns. The view date columns where the actual data is not changed, just how it is displayed. This helps to keep the data looking consistent even if the provided data is not. This can be enabled by using with the M column type for theColumn Typestypes parameter corresponding to the column. Advanced Date Sortingdate sorting specifies how to use the M column type to customize how the column data is interpreted as a data. With an additional specification, the format of how the date should must appear when viewed.
Two date formats are needed to support both interpreting the data and formatting the output.
- Input format - this is first format specified on the M column type, although it is usually defaulted when nothing is specified, the default format is used. SeeAdvanced Date Sorting for date sorting for more details.
- Display format - this is how you want the date to be displayed and sorted. If not specified, the column displays is displayed as-is. The display format is similar but, necessarily, more complex than the input format. It is summarized below. The ~ character is used to separated the input and display formats to avoid most conflicts with characters used in formats. This is summarized in the succeeding sections.
Examples
Column type | Input format | Display format |
|---|---|---|
M~YYYY.MM.DD | <default> | YYYY.MM.DD |
MDDMMMYYYY~YYYY.MM.DD | DDMMMYYYY | YYYY.MM.DD |
M(de)DDMMMYYYY~YYYY.MM.DD | (de)DDMMMYYYY | YYYY.MM.DD |
| MX~DD.MM.YY | Unix timestamp | DD.MM.YY |
MDD MMM YYYY~YYYY.MM.DD | DD MMM YYYY Default Confluence Date Picker (US) | YYYY.MM.DD |
Usage
The Formatting Options formatting options listed on this page can be defined through theColumn Typestypes parameter within the following Macrosmacros:
- CSV macro
- Table Plus macro
- Attachment Table macro
- JSON Table Macro
- SQL Macro
- SQL-query Macro
- SQL-file Macro
- Excel Macro
Screenshot
Formatting
...
options
| Info | ||
|---|---|---|
| ||
Advanced date sorting support with the M column type is provided using javascript Javascript implemented by the TBLSORT 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|