Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

CSV import Unparseable date

Domènec Cintes
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 12, 2021

I have a problem with dates when import issues with csv import tool.

Unable to parse created date: 09/07/21 9:21 AM
Unable to parse created date: 08/07/21 9:15 AM
Unable to parse created date: 07/07/21 11:56 AM
Unable to parse created date: 06/07/21 1:03 PM
Unable to parse created date: 01/07/21 12:10 PM

In the first step i define de format: "dd/MM/aa h:mm a"

I try multiples formats but always get the same error.

Dates from csv:
,09/07/21 9:21 AM,12/07/21 9:20 AM,12/07/21 12:38 PM,

Format from config file:
"config.date.format" : "dd/MM/aa h:mm a"

Thanks,

1 answer

1 accepted

0 votes
Answer accepted
Dave Bosman [Realdolmen]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 13, 2021

Hi @Domènec Cintes 

I could be wrong here, but could you try

dd/MM/yy h:mm a

Regards

Dave

Domènec Cintes
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 13, 2021

Right, I'm blind ... I don't know why I changed "y" to "a"

Thanks,

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events