| Info |
|---|
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 , : click toggle ''Enable date 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 two 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.
...
...
In this case, the last saved date format will be displayed in worksheet.
| Info |
|---|
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. |
...
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
If you are interested in more detailed formats, visit: https://js-joda.github.io/js-joda/manual/formatting.html.
...