nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

import csv with date

Suma Pralhad Kustagi

Hi,

I am trying to import a cvs file but i get error stating as

Unable to parse datetime: 21/1/21 using the date format pattern: dd/MMM/yy h:mm a

How to resolve this..

Regards,
Suma

Accepted answers

KAGITHALA BABU ANVESH_z1zl10

hello @Suma Pralhad Kustagi ,

please try this below format

16/06/2021 12:58 with a date mask of dd/MM/yyyy hh:mm.

KAGITHALA BABU ANVESH_z1zl10

Hello @Chitra D ,

16/06/2021 12:58 with a date mask of dd/MM/yyyy hh:mm.

Please change the format in the csv file.

Thanks,

Anvesh

All comments

KAGITHALA BABU ANVESH_z1zl10

hello @Suma Pralhad Kustagi ,

please try this below format

16/06/2021 12:58 with a date mask of dd/MM/yyyy hh:mm.

Suma Pralhad Kustagi

Hi Anvesh,

Thank you for the quick support. Able to upload the CSV...

Regards,

Suma

Chitra D

I am still not able to import with the suggested Date format. Still getting same error "Unable to Parse date"

Suma Pralhad Kustagi

Hi Chitra,

Can you share the screen shot so that can identify whats the issue...From starting ie Import CSV,etc...

Regards,
Suma

Chitra D

Thanks Suma for the quick response. Here is the screenshot.

I have tried all different Date formats. And my csv file is an Excel CSV UTF-8

Suma Pralhad Kustagi

Hi Chitra,

Please share this type of screenshot, while upload of csv..

Regards,

Suma

KAGITHALA BABU ANVESH_z1zl10

Hello @Chitra D ,

16/06/2021 12:58 with a date mask of dd/MM/yyyy hh:mm.

Please change the format in the csv file.

Thanks,

Anvesh

Chitra D

HI Anvesh,

Yes I got it resolved. I did custom format in CSV excel for date field d/mmm/yy and it worked.

Thanks for your response.

Appreciate it!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud