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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.