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,363,252
Community Members
 
Community Events
168
Community Groups

Unable to parse Date, CSV Imports

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

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.

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

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.

Alex, thanks for the solution.  

Suggest an answer

Log in or Sign up to answer