Unable to parse Date, CSV Imports

[Madhu Mullangi]

I am getting this error while Importing issues.

Unable to parse date: 11-12-2018

[Rambabu Patina _Appfire_ · Accepted solution]

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:

'

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

Thanks,
Ram.

[Madhu Mullangi]

Hi Ram,

Please have a look on the attached Image.

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

[Rambabu Patina _Appfire_]

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'.

[Madhu Mullangi]

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

Thanks in Advance

[Rambabu Patina _Appfire_]

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

[Madhu Mullangi]

Yes 

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

[Rambabu Patina _Appfire_]

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

Try like here as your csv has the same format:

[Madhu Mullangi]

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

[Masarla Venkateswarlu Reddy]

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

[eyepax_MenakaS]

@Masarla Venkateswarlu Reddy thanks, saved my day

[Mark Mulik]

I kept struggling with this problem and these answers and have another idea for the group. 

By changing the source format to be as indicated in the CSV file (bubble #1) and then changing the Date format in the External System Import setup page to be as indicated in bubble #2, I was able to successfully import a Due Date. Due Date doesn't appear to care about the time value, but the import file will be rejected without it. The key to making this Date format here work that the characters in the format are case sensitive! A thorough review of the article referenced on that page (SimpleDateFormat (Java 2 Platform SE 5.0) (oracle.com)) makes clear that the uppercase H for hours stands for hours in military time. 

In Excel, be sure to format the text of the cell to be "Text" so that Excel doesn't, um, "helpfully" change the format after you key it in just the way you want it. 

[Rob Horan]

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

[Rob Horan]

The answer is to modify the date-only values, so they have dummy time values, set the date format as date and time, and Import the date values into date fields where the dummy time values will be ignored.

[Sten Kivi]

Tested with YYYY.MM.DD and also worked for me.