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
4,298,196
Community Members
 
Community Events
165
Community Groups

JIRA tasks from CSV file have wrong date imported

Hi,

I am trying to import issues from .csv file and issues (testing with 3 rows first) have been created in JIRA. However the due date in JIRA issue is completely different from what is specified in my csv file.

Date in CSV - 3/26/2022

Date in JIRA - 26/Dec/21

I have about 1002 issues to create from csv file and cannot afford with no correlation in the due dates. Please post your valuable inputs to resolve this issue. Thanks!

 

2 answers

Hi @Uma Kesavan ,

Welcome to the community.

You need to choose the right date format that matches exactly what you have in your CSV during the import. Steps are described in https://confluence.atlassian.com/jirakb/dates-are-not-properly-imported-from-csv-file-245825977.html 

Hi @Uma Kesavan ,

Please try to make date format as dd/MMM/yyyy h:mm for date and time dd/MMM/yyyy  for date fields and in the created excel sheet .these are default format for jira.

Please make try with this and let me know f it helped.

Thanks,

Ajay

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you