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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

import csv with date

Hi,

   I am trying to import a cvs file but i get error stating as 

Unable to parse datetime: 21/1/21 using the date format pattern: dd/MMM/yy h:mm a

How to resolve this..

 

Regards,
Suma

3 answers

2 accepted

0 votes
Answer accepted

hello @Suma Pralhad Kustagi ,

 

please try this below format

16/06/2021 12:58 with a date mask of dd/MM/yyyy hh:mm.

Hi Anvesh,

    Thank you for the quick support. Able to upload the CSV...

Regards,

Suma

0 votes
Answer accepted

Hello @Chitra D ,

 

16/06/2021 12:58 with a date mask of dd/MM/yyyy hh:mm.

Please change the format in the csv file.

 

Thanks,

Anvesh

HI Anvesh,

Yes I got it resolved. I did custom format in CSV excel for date field d/mmm/yy and it worked.

Thanks for your response.

Appreciate it!

I am still not able to import with the suggested Date format. Still getting same error "Unable to Parse date"

Hi Chitra,

    Can you share the screen shot so that can identify whats the issue...From starting ie Import CSV,etc...

 

Regards,
Suma

Thanks Suma for the quick response. Here is the screenshot. 

I have tried all different Date formats. And my csv file is an Excel CSV UTF-8CSVerror.PNG

Hi Chitra,

   Please share this type of screenshot, while upload of csv..

 

Regards,

SumaCSV.PNG

JIRA DATE.PNG

Here it is Suma. I tried N number of different formats in my Excel CSV file, its not taking any.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

931 views 2 22
Read article

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