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,368,979
Community Members
 
Community Events
168
Community Groups

Unable to parse Date, CSV Imports

I am getting this error while Importing issues.

 

Unable to parse date: 11-12-2018

2 answers

1 accepted

4 votes
Answer accepted

Hi @Madhu Mullangi,

What is the date format you have set on step 2 in the CSV import process?

To verify see the screenshot for understanding:

Screenshot 2019-01-21 at 3.15.21 PM.png'

Have a try correcting to the right date format and let us know how it goes.

Thanks,
Ram.

Hi Ram,

Please have a look on the attached Image.

 

I am using dd-MM-yyyy format, And getting this error.date.PNG

Please make sure you are using the same format in both the CSV file and while importing into Jira.

If your CSV file has the format 'dd-MM-yyyy' (i.e with dashes) then make sure you set the format in step 2 as 'dd-MM-yyyy'.

I hope i am using the same format. If not please correct me.

Thanks in Advanceformat.PNG

The format looks good in the CSV file. Please check the format while CSV importing in step 2. Set like 'dd-MM-yyyy'

Yes date.PNG

 

I am using the same format, Still having the same error 

The attached screenshot referring you are using a different format in step 2.

Try like here as your csv has the same format:

Screenshot 2019-01-22 at 5.51.15 PM.png

Changed the format according to your Screenshot, Still facing the same Issue

Change the format to d-m-yyyy (12-11-2018) instead of dd-MM-yyyy.

Follow the pattern as given examples

If date format is 2-1-2020 use d-m-yyyy 

else if 2-01-2020 use d-mm-yyyy

else 02-01-2020 use dd-mm-yyyy

Like # people like this
0 votes

What if some fields are date only and others are date and time?

Suggest an answer

Log in or Sign up to answer