This feature is only available since version 2.5.0 of Excel 365 Connector
To have date in Excel sheet in selected format: click toggle ''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 two types of dates:
date without time,
date with time,
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.
In this case, the last saved date format will be displayed in worksheet.
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 |
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.