Issue with Import of CSV with Start and End Dates

[Jamie Meredith]

I am banging my head against the wall trying to import start and end dates for a simple single task with a summary and a set of start and end dates for the task.  

The end goal is to be able to import a set of tasks into Jira WM with the task (summary) and a start and end date.  I have tried more than 15 times of this scenario with only a summary and the start and end dates and it fails to insert the start and end dates (both as custom fields and reusing fields already established in our system).  I have tried adjusting the formatting, I have tried exporting defined records with start and end date and then re-importing.  All of them fail.  Please help. 

[David Nickell]

This was so much tougher than I thought it would be ... but I have a (verifiable) answer.

I tried many times to get the the CSV to honor the suggested format but no matter what I did, the date was still stored in a format Excel preferred.

I finally decided to see if I could get Jira to understand the Excel format. 

So -- in Excel (CSV), my date looks like this 12/13/2024

On the second screen of the import process, I changed the format to M/d/y

This first screen shot shows the change to make

This second screenshot is to hopefully convince you that it really is a single capital M for month.  Just like the documentation says.  My January records exist because I was using multiple combinations of lower case M's 

Enjoy

[Carlos Garcia Navarro]

Thanks for sharing!

[Carlos Garcia Navarro]

Hi @Jamie Meredith ,

Welcome to the Community! What formats did you use? Did you try 'dd/MMM/yyyy' (e.g.: 29/Aug/2023)?