CSV import Unparseable date

[Domènec Cintes]

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,

[Dave Bosman _Inetum_ · Accepted solution]

Hi @Domènec Cintes 

I could be wrong here, but could you try

dd/MM/yy h:mm a

Regards

Dave

[Domènec Cintes]

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

Thanks,