Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Why is my date being imported incorrectly?

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.



1 answer

1 accepted

1 vote
Answer accepted
Rachel Wright
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 25, 2018

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

@Rachel Wright  if I use the default d/MMM/yy, what the actual date will look like after loading into jira? 


Us there any details instruction that can help me format it on the csv file?


Thanks in advance 

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events