Date Format in JQL extract

[Godwin Labouh]

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 solution]

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

[Godwin Labouh]

Thank you Florian, that was very helpful !

Best

Godwin

[Aron Gombas _Midori_ · Accepted solution]

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.)

[Godwin Labouh]

Thank you Aron!