Unable to import proper date format

[Pradheep Ayyanar]

Hi All

I am trying to import CSV to create sub-task with few date fields and all are imported successfully.

But the date fields are always wrong.

Input in CSV: 02/05/2024 [mm/dd/yyyy]

import csv format: mm/dd/yyyy

Jira sub-task fields show as Jan 05,2024

For all the dates imported, the date is correct and the month is always JAN. can someone help to fix.

Pradheep

[Christof Hurst]

mm is minute. Month is MM or MMM. Please see example under the field and documentation link from SimpleDateFormat

[Tomislav Tobijas _Koios_]

Hi @Pradheep Ayyanar ,

It's been a couple of months now but I think I stumbled upon the same issue when it comes to importing dates (we were using Jira Cloud). I don't recall finding some smart solution other than just changing the format of dates in the CSV file to the default one dd/MM/yyyy. At least that's what I've highlighted in our internal documentation.

So, I would recommend trying this 'workaround' but it might not be so convenient if you're importing issues on a regular basis.

Also, I can see that the cloud has a new CSV importer now which I didn't check yet.

Best regards,
Tom

[Christof Hurst]

It's just the wrong use of mm instead of MM.

[Krista Stellar]

Agree with the others who have pointed out the issue with using the capital 'M' in the date format. I will also suggest checking that the CSV export from your spreadsheet hasn't shifted the date format on you. Both things happened to me when doing an import.

I can no longer find the community article I found that led me to examine the dates in my csv file (in a text editor, not in a spreadsheet). The underlying issue is that the spreadsheet application may be applying a format to present the dates to you but when you export to CSV that formatting is not retained and the dates are exported in a different format than how it is displayed.

If changing the date format specification doesn't resolve the issue entirely then do examine the CSV file to see if the dates are still in the expected format.

Good luck!