Unable to parse Date, CSV Imports

Aravind Koushik Gobburu December 16, 2021

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

resolved.png

I have set the default format as follows.

resolved1.png

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

2 answers

1 vote
Mark Segall
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 16, 2021

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 December 16, 2021

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 December 18, 2021

Hi @Mark Segall ,

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

Like Virginie likes this
Alex Ortiz December 19, 2021

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 1, 2022

Alex, thanks for the solution.  

0 votes
Drew Kerrigan May 21, 2024

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

 

Suggest an answer

Log in or Sign up to answer