Versions Compared

Key

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


Div
idProductTOC

On this page

Table of Contents
maxLevel1
excludeOn this page
typeflat
separatorpipe

Overview

Starting with Version 6.4 of the Advanced Tables for Confluence add-on, it is possible to specify the format that is used to view date columns. 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 the M column type for the Column Types parameter corresponding to the column. Advanced Date 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 appear when viewed.

...

  1. Input format - this is first format specified on the M column type, although it is usually defaulted when nothing is specified. See Advanced Date Sorting for more details.
  2. Display format - this is how you want the date to be displayed and sorted. If not specified, the column displays 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.

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.YYUnix timestampDD.MM.YY

MDD MMM YYYY~YYYY.MM.DD

DD MMM YYYY

Default Confluence Date Picker (US)

YYYY.MM.DD

Usage

The Formatting Options listed on this page can be defined through the Column Types parameter within the following Macros:

Screenshot

Formatting Options

Info
titleAcknowledgement

Advanced date sorting support with the M column type is provided using javascript implemented by the TBLSORT 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
highlightColor#ffffec
rowStylesbackground:#f0f0f0;color:#222;font-size:14px;border-bottom:black 2px solid;border-top:black 2px solid;,
stylebackground-color:white;


 

TokenOutput
MonthM1 2 ... 11 12

Mo1st 2nd ... 11th 12th 

MM01 02 ... 11 12 

MMMJan Feb ... Nov Dec 

MMMMJanuary February ... November December
QuarterQ1 2 3 4
Day of MonthD1 2 ... 30 31 

Do1st 2nd ... 30th 31st 

DD01 02 ... 30 31
Day of YearDDD1 2 ... 364 365

 DDDo1st 2nd ... 364th 365th 

DDDD001 002 ... 364 365
Day of Weekd0 1 ... 5 6 

do0th 1st ... 5th 6th 

ddSu Mo ... Fr Sa

 dddSun Mon ... Fri Sat 

ddddSunday Monday ... Friday Saturday
Day of Week (Locale)e0 1 ... 5 6
Day of Week (ISO)E1 2 ... 6 7
Week of Yearw1 2 ... 52 53

 wo1st 2nd ... 52nd 53rd 

ww01 02 ... 52 53
Week of Year (ISO)W1 2 ... 52 53 

Wo1st 2nd ... 52nd 53rd 

WW01 02 ... 52 53
YearYY70 71 ... 29 30 

YYYY1970 1971 ... 2029 2030
Week Yeargg70 71 ... 29 30 

gggg1970 1971 ... 2029 2030
Week Year (ISO)GG70 71 ... 29 30 

GGGG1970 1971 ... 2029 2030
AM/PMAAM PM 

aam pm
HourH0 1 ... 22 23 

HH00 01 ... 22 23

 h1 2 ... 11 12 

hh01 02 ... 11 12
Minutem0 1 ... 58 59 

mm00 01 ... 58 59
Seconds0 1 ... 58 59 

ss00 01 ... 58 59
Fractional SecondS0 1 ... 8 9

 SS0 1 ... 98 99 

SSS0 1 ... 998 999
Timezonez or zzEST CST ... MST PST 
Note: as of 1.6.0, the z/zz format tokens have been deprecated. Read more about it here.

 Z-07:00 -06:00 ... +06:00 +07:00 

ZZ-0700 -0600 ... +0600 +0700
Unix TimestampX1360013296


Internationalization

See language support (i18n).

...