Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,733
Community Members
 
Community Events
165
Community Groups

Unable to parse date CSV import impossible

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 May 03, 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

It seems that the same bug appears.

Dirk Ronsmans Community Leader May 03, 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.

non valid format.PNG

Invalid format... Confusing ! 

Dirk Ronsmans Community Leader May 03, 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

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
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you