Unable to parse Date, CSV Imports

[Aravind Koushik Gobburu]

I am trying to import resolved date which is shown in the screen shot below.

I have set the default format as follows.

Still getting the error as:-

• Unable to parse datetime: 18-Sep-19
• Unable to parse datetime: 13-Sep-19
• Unable to parse datetime: 24-Apr-19
• Unable to parse datetime: 25-May-20
• Unable to parse datetime: 27-Apr-20

[Drew Kerrigan]

The external importer is a bit tricky.

I've seen the import work with any datetime format using the SimpleDateFormat: https://docs.oracle.com/javase/1.5.0/docs/api/java/text/SimpleDateFormat.html

However it always says:

"...completed with warnings..."

"Unable to parse datetime..."

The only datetime format that I have seen it accept and not throw any errors with, is this:

M/d/yyyy H:mm:ss

[Casey Cochran]

I have spent waaaaaaaaaay too much time on this trying different formats. Was about to give up but @Drew Kerrigan , your comment was the key. Thank you 

[Mark Segall]

Hi Aravind,

You're so close... Note in the example that you should be using forward slashes instead of dashes:

18/Sep/19

That should do the trick.

[Alex Ortiz]

Importing dates are tricky.  I've had GREAT success by formatting my csv to be MM/dd/yy.  

When I import, I basically have 12/12/21 and this works really well for me.

I struggled a lot to finally find a format that actually stuck.

[Aravind Koushik Gobburu]

Hi @Mark Segall ,

I have formatted my csv file to dd/MMM/yy also.But i am facing the same error.

[Alex Ortiz]

I ran into the same issue.  I had to update my CSV and my Jira settings to match MM/dd/yy. 12/20/21. This worked well for me.

[Matthew Youell]

Alex, thanks for the solution.