Unable to parse date CSV import impossible

Valerie Mejsnarova May 3, 2022

Hello, 

I have already read some topics about this issue but I still can't achieve to import my data as I this error:

But, when I'm importing, I have my right date time format. 

Can you help me ? 

Thankserreur import.PNGCapture.PNG

1 answer

1 vote
Dirk Ronsmans
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 3, 2022

Hey @Valerie Mejsnarova ,

Since you are using the 24hour format can you try it with:

dd/MM/yyyy HH:mm

1. d/D: day without 0 prefix on single digit. 
2. dd/DD: day with 0 prefix if single digit.
3. M: Month without 0 prefix on single digit.
4. MM: Month with 0 prefix if single digit.
5. yy/YY: Last two digit of year.
6. yyyy/YYYY: represents full year.
7. HH: 24 hour based hour. ie. 13:00. **H** will display hour without prefix 0 if single digit
8. hh: 12 hour based hour. ie. 01:00. **h** will display hour without prefix 0 if single digit
9. m: minute without 0 prefix on single digit. 
10.mm: minute with 0 prefix if single digit.
11.s: second without 0 prefix on single digit. 
12.ss: second with 0 prefix if single digit.
13.tt: represent the AM or PM
Valerie Mejsnarova May 3, 2022

It seems that the same bug appears.

Valerie Mejsnarova May 3, 2022

bug 2.PNG

Dirk Ronsmans
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 3, 2022

I wonder if this has something to do with the language setting your have as it is in French. 

Looking at the example underneath your formatting it seems that it's expecting day as jour and year as annee.

Any chance you try:

jj/MM/aaaa HH:mm

 

i'm just guessing here at this time cause of the example and maybe your system language.

Valerie Mejsnarova May 3, 2022

non valid format.PNG

Invalid format... Confusing ! 

Dirk Ronsmans
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 3, 2022

Out of ideas here.. besides the side step to French I would have thought the original formatting with HH would have worked.

Could you maybe share that one line in the csv? (after cleaning up personal info of course).  Just wanna see if I can get it working locally

Valerie Mejsnarova May 4, 2022
Date 1;Date 2;Date 4
17/03/2023 14:30;18/04/2023 14:01;19/04/2023 14:01

Here are my test lines.

Suggest an answer

Log in or Sign up to answer