Data migration problem

Question

Dear Support,

Despite doing the right configuration data mapping , and ensuring that the time format is the same for both JIRA and the site my team is migrating from , date data is wrongly imported. Specifically, JIRA date configuration is : m/d/yyyy h:mm same as in the Excel -CSV I'm uploading ( External System Import) yet instead of March , JIRA displays January (day and year are correct) .What should I do?

Tahnks a lot in advance

Margarita_Papadaki · Answer

Ultimately I had to go to settings--?general settings-->Advanced settings and chenged the format of date picker

Margarita_Papadaki · Answer

thanks a lot!

Radek Dostál · Answer

Months, days and hours are two-digits, therefore m/d and h are invalid. Are you sure that is the right format?

If you're on self-hosted, you can see the date formats in general configuration.

On Cloud this appears to be in Look and Feel: https://support.atlassian.com/jira-cloud-administration/docs/configure-the-look-and-feel-of-jira-applications/

Excel might be showing it correctly, but it's not a valid format as per https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html and I do doubt that is indeed the format you have set up in Jira.