Update Fields via CSV Import - Due date field

[Valerie Capasso]

I need to bulk update the Due Date field for 1000+ issues. I followed the directions here and here .

I created a CSV file that contains the Issue Key, Summary, Issue Type and Due Date fields. I follow the steps in the External Import Wizard but after the import/update is finished, the Due Date field is populated with 1/15/2023 for most of the issues listed in my CSV. That is not the correct value for the field. See screenshots.

I can't figure out why its not properly updated the Due Date field with the data from the sheet.

[Brant Schroeder]

@Valerie Capasso 

The date format in Jira by default is dd/mmm/yy h:mm. Try changing the format to dd/mm/yy and import it should import your csv file or import the value as dd/mmm/yy h:mm (eg: 15/Jul/23 01:22 )

[Valerie Capasso]

I updated the date format to: mm/dd/yyyy to match the format from my file.

[Fabian Lim]

Hi @Valerie Capasso

Can you share the formatting you are using for the date import?  is it M/dd/yyyy?

[Valerie Capasso]

I updated the date format to: mm/dd/yyyy to match the format from my file.

[Valerie Capasso]

I figured it out... it was b/c I did mm/dd/yyyy. When I updated to MM/dd/yyyy it imported the dates correctly.

[Kelly Arrey]

@Valerie Capasso Glad you figured it out.  I got bit by that a few days ago.  For those following along at home, this is because Jira understands mm as minutes and MM as month, e.g., 

`dd.MM.yyyy HH:mm' 

[Sten Kivi]

Thank you @Kelly Arrey 

dd.MM.yyyy fixed my issue.  I was using DD.MM.YYYY

[Hannes Obweger - JXL for Jira]

Hi @Valerie Capasso

I'm glad to hear that you got your issues resolved. Just for future reference, if these kinds of bulk imports are something you do more frequently, you might consider checking the Atlassian Marketplace for solutions that make this process easier.

Just as an example, my team and I work on an app - JXL for Jira - that allows viewing and inline-editing your issues much like you'd do in Excel or Google Sheets, including the ability to copy/paste values between Jira and other apps. This way, bulk editing thousands of issues may be as simple as two keyboard shortcuts:

Of course, this would work for the due date, too.

As said above: This is just one example for a Marketplace app that could help with your task. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Best,

Hannes