[JIRA] how to change date format in report graph and exported csv?

[Hongya Cui]

I've tried this: https://confluence.atlassian.com/jira/__date-and-time-formats-228065889.html?_ga=2.8265335.457014188.1534054440-1730287274.1525872375

but it doesn't affect to report graph and exported csv/html

[AhmadDanial · Accepted solution]

Hi, Hongya.

Before we dig deeper into this case, allow me to gather some additional details to understand the issue better:

• What version of JIRA you are running on specifically?
• Are you using Java / JavaScript format?
• Which format of the date time that you are using?
• How did you change the settings on your JIRA instance? Was it done under the Advanced Settings?
• Can you compare the settings that you are currently using and the output that you are seeing on report graph and csv / html please?

Looking forward to hear from you soon. Thanks.

[Hongya Cui]

Hello Ahmad,

1 7.9.2 and upgraded to 7.11.2

2 I set jira.date.picker.java.format to yyyy-MM-dd

and jira.date.picker.javascript to %Y-%m-%d

3 what does it mean? 

4 please see no.2, I changed it under Advanced Settings.

5 on report and exported csv, it shown as jira default format: dd/MMM/yy and dd/MMM/yy h:mm a  

[AhmadDanial]

Hi there, Hongya.

Thank you for the clarification. So, the advanced settings that you have made changes to only applies to the date / date time picker field in JIRA screen, instead of the format in the report and csv export. As we can see here:

As you can see here, the changes get reflected in the following date picker field:

But not on the reporting side and the csv export:

I came across the following bug report that was closed but it was not clear where it is currently being tracked - JRASERVER-59791: Date/DateTime Picker log format different in UI and Date exported to excel shows different date

Please let me know if you would like me to have a new Suggestion created instead to keep track of this. Thanks.

[Hongya Cui]

Thank you.

particularly, MMM with utf-8 character cannot be shown correctly on the report,  

so the issue you posted does not fully reflect the problem.

[AhmadDanial]

Hey, Hongya.

You are welcome. I have tried to reproduce the issue on my end by setting the Default Language to the following:

However, the date is still shown in English as we can see in the screen shot below:

Therefore, we would like to verify on the following:

• Did you change the default language of the browser? If yes, can you show us how this is done?
• Can you confirm on the web browser that you are accessing JIRA from?
  • If Google: Standard or Incognito mode?
  • If Safari / Firefox: Standard or Private Browsing?
• Is it constantly reproducible in other browsers too? 
• Was the report month on the graph displayed correctly prior to the upgrade?

I look forward to hear from you soon. Thanks.

[Hongya Cui]

1 No, because I live in China, so my default language is Chinese

2 Standard Mode, Chrome.

3 Yes, I tried on Edge.

4 I never tried before.

5 I installed jira on Chinese Version Windows Server 2016

[AhmadDanial]

Hi, Hongya.

Understood. Since I do not have the same version of Windows Server handy on my end, I cannot tell for sure if this is specific to the environment that you are running on. Hence, I would like to ask if you are able to check this with any of your colleagues who are also a user in this instance to have this tested and reproduced on their machine as well and verify the behavior.

Should it be consistent, let us raise a bug ticket to the dev team to look into this matter. Thanks.

[Hongya Cui]

I've tried to change windows region settings: changed date format, and month displayed language,

but it doesn't work……

trying other machine...

[Hongya Cui]

I've tried on a english OS machine, it's still 口口 and Chinese month name.

finally, added

-Duser.language=en -Duser.region=US  to service startup option solved problem, it's shown as english.

but I think the locale and date format should be configured inside application. I want to customize date format here, and chinese character should be shown correctly on graph.

so please help me raise a issue.

Thank you.

[AhmadDanial]

Hi, Hongya.

Thank you for the update from your end. I came across the following documentation which explains that some of the functionalities in JIRA depends on the locale that is set for the JAVA environment.

• Setting Locale in JIRA

Which possibly explains the reason why the changes only get reflected when you set the parameters accordingly. We have an existing bug report raised for this as per the following link:

• JRASERVER-35195: Multiple Issues With Charts in Dashboard/Project Summary with Korean/Japanese/Chinese Language

I encourage you to visit the bug page linked above and click the Watch link near the top right to show support for the feature. By doing this, it will ensure you are proactively informed of progress and updates going forward.

I also recommend you to share your feedback. You can do this by leaving a comment on the ticket as this helps us prioritize the bug better. 

[Hongya Cui]

Thank you！ 

[AhmadDanial]

Hi, Hongya.

You are most welcome! Please feel free to accept my answer as a solution if you do not have any further questions. Thanks!