Add Advanced Date Sorting Using the D Column Type

On this page

Overview

This applies to all versions of Advanced Tables for Confluence and other sorting enabled macros. However, for plugin versions 6.x and above, better support is available using the M column type. The D column type remains available for compatibility. See Advanced Date Sorting for more details.

The default date handling (using the D column type) provides support for the browser default date format. This may not work properly for columns that have a date format that is different than the default format set for individual browsers. More advanced and automatic capabilities are possible provided your administrator has provided an extension that supports this. 

Steps

If this support is available on your installation:

  1. Specify the D column type on the columnTypes parameter. This will automatically match successfully on many popular standard date formats. 
  2. For more unique date formats, specify the D column type followed by a valid date format

Date Format Examples

Basic

Column type

Example date

DBrowser default handling

Advanced

  • Available if administrator has installed
  • Not available for Cloud

Column type

Example date

D

Many popular date formats

DMM/dd/yyyy

01/08/2007

D"MMM d, yyyy"

Jan 8, 2008