Custom date formatting

For charts with date or datetime axes, Atlassian Analytics has pre-defined formats that you can choose from to display those dates and times in your chart’s axis labels. If you don’t see a pre-defined option that meets your needs, you can provide a custom date format to use in your chart’s axis labels. Custom date formats let you specify the exact way you want to display your date labels in the chart.

To use a custom date format:

1. Open the chart settings of the chart.

2. Go to the Axis tab.

3. For Date format of your date axis, select Custom.

4. Provide a format string using any of the format directives listed below. The default format string is %Y-%m-%d.

Examples of format strings

Use any of these common format strings for your custom date format:

• %m/%d/%Y separates the month, day, and year by a forward slash (/)—for example, 01/31/2022.

• Q%q shows the quarters as Q1, Q2, Q3, or Q4.

• %-m/%-d shows month and day without prepended 0s. For example, January 2nd would show as 1/2.

• %b %_d, %y shows dates as Feb 4, 22 for example.

• %d.%m.%y separates the day, month, and year by a period (.)—for example, 31.01.2022. Switch the order around and notation for a Spanish date system.

Available format directives

Directives return the desired part of a date or timestamp. Use a combination of static text and any of the following directives to create your custom format string:

Dates

Times