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,

Date formatting

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.

Invalid pattern

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

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: js-joda.

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.