Date Format in JQL extract

Question

Hi

How can I obtain a jql query extract with consistent date format in Excel.

I'm getting some records in the format dd.mm.yyyy HH:mm whoich is fine. I'm however also getting some date records in the format dd/mmm/yy HH:mm AM/PM which is giving problem in Excel.

Thanks in advance

Godwin

Florian Bonniec · Accepted Answer

Hi @Godwin Labouh

You may need to not open it with excel right away but import the csv then follow the wizard to specify column type.

Once you download the file please open it with a text editor to see if the data is right or weird like you see in excel. If you have different format it's porbably excel that miss interpret the date then auto-save the wrong date in the file.

Regards

Aron Gombas _Midori_ · Accepted Answer

If you want to produce a real XLSX file with the expect date and date time format values, use this app:

https://marketplace.atlassian.com/apps/1212652/better-excel-exporter-for-jira?hosting=cloud&tab=overview

It will use a consistent format, which you can even customize in "field-helper.groovy":

...and even use the format native to the user locale:

Happy exporting!

(Discl. it is a paid and supported app, that my team develops to get better quality and feature-rich XLSX output from Jira.)