| Div | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
Overview
...
Overview
This example explains how to format the display of date columns without changing the actual data. This helps to keep the format consistent even if the format of the provided data is not. This can be enabled by using To do this, configure the appropriate columns with the M column type for in theColumn Typestypesparameter corresponding to the column. Advanced Date Sortingdate sortingspecifies 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 appear when viewed.Two date formats are needed to
In this page, two formats that support both interpreting the data and formatting the display (output) of the data are explained.
- Input format -
...
- This is
...
- the current format specified on the M column type
...
- ; if nothing is specified, the default format is used. See Advanced date sorting for more details.
- Display format -
...
- This is how you want the date to be displayed and sorted. If not specified, the column
...
- is displayed in the same format as the input format. The display format is similar but, necessarily, more complex than the input format
...
- . The ~ character is used to
...
- separate 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:
...
- Table Plus macroAttachment Table
- CSV (Comma Separated Values) macro
- JSON Table Macro
- Attachment Table macro
- SQL Macromacro
- SQL -query MacroFile macro
- SQL -file MacroQuery macro
- Excel Macromacro
Screenshot
Formatting
...
options
| Info | ||
|---|---|---|
| ||
Advanced date sorting support with the M column type is provided using javascript implemented by the TBLSORT Javascript with the help of the Moment.js library (open source, MIT license). A summary of the relevant parts of the momentMoment.js documentation is repeated here. |
| Table plus | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|