| Div | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
Overview
This applies to all versions of Advanced Tables for Confluence and and other sorting enabled macros. However, for plugin versions 6.x and above, better support is available using the Date (M) column type. The Date in the browser date format (D) column type remains available for compatibility. See Advanced Date Sorting for more details.
The default date handling (using the Date in the browser date format (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.
| Tip | ||
|---|---|---|
| ||
Advanced data handling capabilities can be made available by installing a specific date handling library. Documentation and source for the library can be found at at JavaScript Toolbox. Install the date.js file on your Confluence server in <confluence-installation-directory>/confluence/includes/js directory. Note that the default date library is in English for date formats that include characters. It is possible to easily modify the date library for other languages before installing it on your server. |
Steps
If this support is available on your installation:
- Specify the Date in the browser date format (D) column type on the columnTypes the Column types parameter. This will automatically match matches successfully on many popular standard date formats.
- For more unique date formats, specify the D column type followed by a valid date format.
| Tip |
|---|
Date formats that contain a comma (,), must be enclosed in a double quote. |
Date
...
format examples
Basic
Column type | Example date |
|---|---|
| Date in the browser date format (D) | Browser 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 |
...