Jira Admin External System Import not updating Resolution Date correctly

[Robb Robins]

Hello!

I am attempting to use External System Import to update the Resolution Date for one issue in Jira (cloud).

Steps:

1. Search for the issue in Advanced Search (issue = XXX-72)
2. Export to Google Sheets
3. Clear all columns except for KEY, SUMMARY, RESOLUTION, RESOLVED
4. Download as CSV
5. Open External Importer (I am a Jira Admin)
6. Choose file (.csv) and select Next
7. Select project, adjust date/time format to match the CSV, and select Next
8. Map KEY -> ISSUEKEY, SUMMARY -> SUMMARY, RESOLUTION -> RESOLUTION, RESOLVED -> DATE RESOLVED, select "Map field value" for each and select Next
9. Manually confirm and select Begin Import
10. Success message "None issues and projects imported." This is the message I get when the import is successful

Here's where the issue is: in the CSV I had set the Resolved Date for 5/11/2022, but the issue in Jira now says 1/11/2022. This is different than the date that was listed before the import (3/4/2023), but not the date I put in the CSV.

Any thoughts as to what is going on?

[Ashish Bijlwan · Accepted solution]

Hi @Robb Robins 

Kindly refer https://docs.oracle.com/javase/1.5.0/docs/api/java/text/SimpleDateFormat.html for the Date Format for External System Import 

Thank you,
Ashish

[Robb Robins]

Hi Ashish,

Thanks for the reply! My dates are formatted correctly, to my knowledge. Do you see something off?

[Ashish Bijlwan]

Hi @Robb Robins 

Please check and change the format to d-m-yyyy (5-11-2022) instead of dd-MM-yyyy.

Follow the pattern as given examples

If date format is 2-1-2022use d-m-yyyy 

else if 2-01-2022use d-mm-yyyy

else 02-01-2022 use dd-mm-yyyy

[Robb Robins]

Following the pattern you show above results in the same result.

The issue still has 01/11/2022 as the resolved date. The CSV I am importing has 05/11/2022 as the value.

[Kelly Arrey]

@Robb Robins

tl;dr

• dd/mm/yyyy is interpreted as Day/Minute/Year
• if you mean Day/Month/Year, use dd/MM/yyyy. 

[Robb Robins]

🤦‍♂️ You solved it, @Kelly Arrey

Thank you so much!

[Kelly Arrey]

Glad that helped!  This has bitten a lot of people recently (don't ask me how I found out about it :-))