-
Suggestion
-
Resolution: Won't Do
NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.
When the language configured in JIRA is different with the Machine OS, exporting filter to excel will cause the date mismatch in term of format and display.
JIRA should parse the Date format in number(perhaps something) rather than the date as the Excel will use the Regional Language in the Machine.
Example:-
JIRA's Language = English
Machine OS's Language = Dutch (Belgium)
When exporting Date Custom Field in JIRA which is supposed to be dd/MMM/yy
Result:-
Expected Result:-
The Date in Excel should all be consistence but due to some conversion made by Excel based on Regional Language of OS's Language.
Workaround:-
Set the same language in JIRA and the OS
Suggestion:-
Parse the date as number instead of MMM?
- is related to
-
JRASERVER-30777 Inconsistency date Export using Date Custom Field with different Language Configured
- Closed