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

1 answer

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 July 1, 2022

Alex, thanks for the solution.  

Suggest an answer

Log in or Sign up to answer