Why is my date being imported incorrectly?

ADMIN_vv3w6t

I am trying to import issues into JIRA via a CSV file. I have a field called Date Created which is mapped to Date Created in JIRA. It has a date format yyyy-mm-dd hh:mm:ss Which is currently set to 2018-03-16 11:00:00

When I import the file via the External System Import and confirm my date format as the above, I do not get any errors and JIRA states that the import has been successful. However, the date is showing as the 16/Jan/2018 11:00 AM.

So instead of importing March, it is importing January.

Thank you in advance for any help you can give.

 

 

Rachel Wright

Hi @ADMIN, you're right; those date formats are tricky! 

I recommend using the format that's set on your applications "Advanced Settings" page.  You can check yours by visiting:  Admin > System > General configuration > Advanced Settings (button on top right).

By default, those formats are:

• d/MMM/yy
• dd/MMM/yy h:mm a

Hopefully you can do a quick format change in Excel and then change back to .csv for the import.

Hope this helps!

Rachel Wright
Author, Jira Strategy Admin Workbook