This feature is only available since version 2.5.0 of Excel 365 Connector
To have date in Excel sheet in selected format, check the box , ''Enable date formatting" and click, "Refresh" button from General menu.
Date formatting allows the user to customize how dates will be displayed on the worksheet. Excel Connector distinguishes three types of dates:
date without time,
date with time,
date with time and timezone.
Each of date types have specific rules and acquires specific data to process. The user can customize this dates in by providing a pattern with given format. This pattern will be used each time an application need to render a specific date. If the user provides the wrong pattern, the application will not process the save step and a specific input will be marked with red border and error icon.
It’s important because if the user tries to put time zone offset in date without time, there is a possibility that such information will not be present. If date formatting is disabled, the default one will be used instead.
All changes made to date formats in Excel Connector won’t affect Jira instance. So, even if you export issues back to the Jira, you will not change the format of custom fields values inside the issue.
Advanced dates formats
To define proper date pattern, user needs to use specific signs and format. The following table provides basic symbols:
Symbol | Meaning | Examples | |
|---|---|---|---|
y | year of the era | yyyy, yy | 2004, 04 |
D | day of year | D | 189 |
M | month of a year | M, MM | 1, 01 |
d | day of a month | d, dd | 8, 08 |
Q | quarter of a year | Q, QQ | 3, 03 |
H | hour of a day | HH, H | 08, 8 |
m | minute of hour | mm, m | 03, 3 |
s | second of minute | ss, s | 06, 6 |
x | x time zone offset | x | +0000 |
Z | z time zone offset | Z | -0800 |
If you are interested in more detailed formats, visit: https://js-joda.github.io/js-joda/manual/formatting.html.
In the current version of the feature, localized formats are unsupported. Localized formats will be introduced in one of upcoming versions of the application. With that problem, we are unable to add support for 12-hour clock time format.