Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Problems when I import dates with CSV

Sofia Grunspan
Sofia Grunspan 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

Answer
Watch
Like Sudarshan likes this
216 views

1 answer

1 vote
Bastian Stehmann
Bastian Stehmann
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
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.

View More Comments
Sofia Grunspan
Sofia Grunspan 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

Like
Bastian Stehmann
Bastian Stehmann
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
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.

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events