Cannot format date correctly when importing issues

[Steve Nienaber]

I am importing Issues from a SCV and cannot find a way for Jira to take my date format.  CSV doesn't seem to allow dd/MMM/yy, which seems to be the only way Jira will import date fields.  

[Tansu Akdeniz]

Hi @Steve Nienaber 

Welcome to the community!

There shouldn't be any problem if format in csv and import wizard matches.

Could you share a sample? Or try another format to import?

Also, please check this Dates are not properly imported from CSV file KB.

[Michelle Gronwold]

You can change the date format on the import screen to whatever you want it to be. Just be sure to keep the month as capital "M"'s. Click on the "SimpleDateFormat" for assistance on the format. How is the date formatted on your spreadsheet? We could possibley help you match the date format for import.

[Jacques]

Hey @Steve Nienaber ,

I usually use the following format for dates: yyyy-mm-dd hh:mm ... this usually works.

Any other method seems to have issues where days and months might get turned around. Eg: 11/03/2023, could be 3rd November, 2023; or 11th March 2023.

Hope this helps,
--- Jacques.

[Steve Nienaber]

Thank you, so to clarify, if I change the format in Excel to this, it should import correctly?  

[Michelle Gronwold]

If you change your Excel date format to "2012-03-14", then you will also need to update the "jira import issues from CSV" date format to "yyyy-MM-dd". Whatever date format you are using in Excel, you will need to modify the Date Format field in jira to match.

[Steve Nienaber]

I changed the Jira date format to yyyy-mm-dd (not yyyy-MM-dd as Excel does not seem to give that option) and this is the result:

[Michelle Gronwold]

Jira needs the capital M's. Lowercase m's in Jira mean something else. 

Excel does not distinguish between lower or upper case in the format. Just jira.