Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how to export any date column with time in excel. currently only date is coming..i need time also

Secure Meters Limited April 16, 2018

how to export any date column with time in excel. currently only  date is coming..i need time also for more analysis

2 answers

0 votes
Alvaro Aranda June 5, 2018

Hi guys!

If you want to change the date format on your exports, you should go to the Look and Feel section on the Jira administration, inside the System part.

There, at the page's bottom, you can find some options to change the date format. I've tested the Created and Due Date fields changing the Complete Date/Time Format option and my exports are managing that dates according to this.

Perhaps, if you're using other particular fields provided by some Apps, it would be renderer on different ways on the exports, you should review the App documentation on that case.

I hope this will help you.

Cheers!

Álvaro.

0 votes
Mauricio Karas
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 16, 2018

Hi there!

Thanks for reaching out to the Atlassian Community.

If you go into Jira Administration > Issues > Time tracking, which format is set in "Time estimates will be displayed in the following format:"? I believe in your case, it should be set as "pretty (e.g. 4 days, 4 hours, 30 minutes)".

Also, which date field are you trying to export to excel? Depending on the case, the field itself could not be saving the time or your user could not be putting in the specific time.

Kind regards,
Maurício Karas

Secure Meters Limited May 31, 2018

Hi,

its shown is grid. but when i am exporting data , its not shown in downloaded csv/excel

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, loom, AI, meeting recording, community

[NEW] Record your meetings with Loom

Welcome to great meetings, with less work. Automatically record, summarize, and share instant recaps of your meetings with Loom AI.

Learn more
AUG Leaders

Atlassian Community Events