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; } } }

Dates not getting rightly populated upon bulk import through CSV

Saad Ahmad_qeav55

Hello, i'm importing epics in bulk through a csv file. Everything is getting populated on the newly created epics except the dates. i tried multiple ways and date formats, but it's always taking month as January (01). Please see the screenshots and guide what mistake I'm making,

date population issue.png

Accepted answers

Ramakrishna _RK_

Hi @Saad Ahmad ,

Welcome to Atlassian Community!

Can you please try format 'dd/mmm/yy h:mm AM/PM' under the custom option of Format cell.

Regards

All comments

Ramakrishna _RK_

Hi @Saad Ahmad ,

Welcome to Atlassian Community!

Can you please try format 'dd/mmm/yy h:mm AM/PM' under the custom option of Format cell.

Regards

Francesco Arieta

You need to choose the correct date format that matches exactly what you have in your CSV when importing. use plain text editor to edit the csv. The steps are described in https://confluence.atlassian.com/jirakb/dates-are-not-properly-imported-from-csv-file-245825977.html

Regards

Vishal Biyani_2pr07j

@Saad Ahmad

To rule out if some automation is overriding the values, can you test by importing the issue and not provide or map "Target Start" and "Target End".

Let's see what happens in this case.

Saad Ahmad_qeav55

@Vishal Biyani

i couldn't find 'dd/mmm/yy h:mm AM/PM' format in excel under 'Custom' tab of format cell.

I tried another this one: dd/mm/yy h:mm, but jira is giving an error while validating the file.
Kindly support. date population issue-1.png

Ramakrishna _RK_

Hi @Saad Ahmad ,

You can type there instead of selection, attached the screenshot for your reference.

Saad Ahmad_qeav55

@Ramakrishna _RK_ it worked, thanks alot

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-cloud

import

date-time