Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Problems when I import dates with CSV

Sofia Grunspan
Contributor
February 1, 2021

Hi! I'm trying to import some CSV files and the Created date in excel has the same format that in Jira. But it doesn't import it correctly.
What can I change to make it work? I've tried before and it worked but now it doesn't.

01.JPG02.JPG03.JPG

1 answer

1 vote
Bastian Stehmann
Community Champion
February 1, 2021

Hi @Sofia Grunspan ,

In the second step of the import  you can set the date format for the import. 

Make sure, that the format there is the same you are using in the csv.

Sofia Grunspan
Contributor
February 1, 2021

Hi! yes I've controlled the format in Jira and the format in Excel match. That's why I don't understand what is happening that dates are not imported.04.JPG05.JPG

Bastian Stehmann
Community Champion
February 1, 2021

Ok, thanks for confirming that.

Probably, it is the formatting of the a.m. Can you try to change a.m. to AM and try again.

Although I don't think that the Month is case sensitive, you could also try Nov instead of nov.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events