/
How to display and customize the Date and Time format in the Advanced Tables for Confluence app hosted on the Data Center using JQL macro

How to display and customize the Date and Time format in the Advanced Tables for Confluence app hosted on the Data Center using JQL macro

Owned by Shubham Shah, created
Last updated: Oct 04, 2024 by Nisha Shantilal
2 min read

This article guides you through configuring the date and time formats in the Confluence Data Center using the JQL Table macro to ensure accurate display in global settings and within the Advanced Tables for Confluence macros.

Instructions

Configure global date format in Confluence

  1. To navigate to Formatting and International Settings:

    • Go to Confluence Administration.

    • Under Configuration, select General Configuration.

    • Go to Formatting and International settings.

  2. Review and configure Date Format

    • Check the current date format setting.

    • If the format is set to MMM dd, yyyy, it cannot capture hours and minutes, resulting in the absence of time display.

    • Change the format to MMM dd, yyyy HH:mm:ss to include hours, minutes, and seconds.

    • After changing this setting, the date and time will be displayed accurately across the Confluence.

image-20240912-060659.png

Configure the date and time display in the Advanced Tables for Confluence

Set up the column format

  1. To ensure the Advanced Tables for Confluence macros display the date and time in the same format specified in the global settings, select the Column type as Date(M).

  2. This will automatically match the date and time format set at the Confluence level.

image-20240912-060905.png

Customize the display format

  1. You can manually specify the format using the desired pattern if you want to display a custom format different from the Confluence global settings.

  2. To customize the date/time display, use the MYYYY-MM-DD T HH:mm:ss.SSS Z ~xxxxx format. Anything specified after the ~ operator will be used as the output format for date and time.

  3. For example, if the global format is EEE, dd MMM yyyy HH:mm:ss z but you only need the date, hours, and minutes in your macro, specify the column type manually as “MYYYY-MM-DD T HH:mm:ss.SSS Z ~YYYY.MM.DD HH:mm"

  4. This configuration will omit the seconds, days, time zones, etc.

image-20240912-061019.png

To learn more about the date and time formats supported by the Advanced Tables for Confluence app, refer to the examples of supported date and time formats.

Related content