Unable to parse date CSV import impossible

Valerie Mejsnarova

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 ? 

Thanks

Dirk Ronsmans

Hey @Valerie Mejsnarova ,

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

dd/MM/yyyy HH:mm

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