Versions Compared

Old Version 1

changes.mady.by.user Smita Nair

Saved on

compared with

New Version Current

changes.mady.by.user Smita Nair

Saved on

Key

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

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
titleAcknowledgement

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
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


Examples

...

M~YYYY.MM.DD

Input format

Display format

<default>

YYYY.MM.DDMDDMMMYYYY~YYYY.MM.DD

DDMMMYYYY

YYYY.MM.DD

M(de)DDMMMYYYY~YYYY.MM.DD(de)DDMMMYYYY

YYYY.MM.DD

MX~DD.MM.YYUnix timestampDD.MM.YYMDD MMM YYYY~YYYY.MM.DD

DD MMM YYYY

Default Confluence Date Picker (US)

YYYY.MM.DD

Internationalization

See language support (i18n).