Unable to parse CSV date

Question

I'm attempting to import a project to a new instance and i keep getting unable to parse date errors.

The date format i use in the import tool is dd MMM yyyy HH:mm

Examples of error messages:

* Unable to parse created date: 21 Mar 2019 15:54
* Unable to parse datetime: 04 Apr 2019 15:59

Prachi Bolar · Answer

Hi Fredrik,

Welcome to community :)

You may also check this document : https://confluence.atlassian.com/jirakb/dates-are-not-properly-imported-from-csv-file-to-jira-245825977.html

Thank you,

Prachi

Jack Brickey · Answer

Hi @Fredrik Sievers , unsure how much research you may have already done. Indeed the date format has always been a bit of a trial and error for me depending on the source format. I find that the following source helps me out - unable-to-parse-date-error-using-csv-import-in-jira-cloud . In that article it references the SimpleDateFormat which I believe is also provided during the import process. Finally, check to be sure your date field includes the time component and if not then exclude from import.