Upload CSV with "Start Date" and "End Date"

[Deleted user]

Hello,

I created a Project with a CSV file which included a "Start Date" and "End Date" fields.

For some reason, the dates that appear in Jira are not the same as the ones that are in the CSV.

The steps I took in Jira:

"Import External Project" --> CSV --> I chose the CSV file --> File encoding: UTF-9 / CSF Delimiter: "," --> Date format --> dd/mm/yyy

I added a screenshot of how I entered the dates in the CSV file (Start Date - Jan 1 2020, End Date June 5 2020)

In my CSV file I have Epics, Stories and Sub-tasks.

I can't figure out how to upload these dates correctly.

Thank you,

Nadav 

[JimmyVanAU · Accepted solution]

Hi Nadav,

Can you check the date format? I'm hoping it's a typo where you've written dd/mm/yyy, instead of dd/mm/yyyy.

I'd also be looking at the raw date in csv, not how Excel parses it. In the window where you can see the file, can you attempt to edit it with notepad/some generic text editor? You may find that Excel is already doing some conversion and the date format is not actually dd/mm/yyyy as it is in the picture.

If you're still stuck, are you able to share a sample of the csv, and perhaps also the import configuration file if available?

[Deleted user]

Thank you @JimmyVanAU 

I found the issue: I need to use uppercase for the month: dd/MM/yyyy not dd/mm/yyy  

[JimmyVanAU]

Great news :) Yes, date formats are sensitive, and so it would have been to looking import minutes and Jira couldn't find a month.

[Joao Zampa]

Watch for spaces, it will break if you have leading or trailing spaces.