import csv with date mistake: "Jan" only

Question

Hello team,

I tried to import csv files into Jira Cloud, with date format yyyy/mm/dd.

While import settings, it seems all okay. However, after "successfully imported",  all months are changed to Jan, but not the original data.

Why would that happen? How should I do to import the right date datas?

Appreciate for any feedback.

here are the sreenshots:

Nic Brough -Adaptavist- · Answer

Yes, but not in a spreadsheet, I'd like to see the raw text of the file you imported.

Spreadsheets tend to try to format your data for viewing, so whilst it looks fine in your screenshot, there's a good chance that is not what is in the plain CSV you are looking at.

Could you open the file in a text editor?  Or just cat it out on a command line and paste us the plain text?

Hancheng Lvsiqing · Answer

Thanks for reply! Do you mean the csv screenshot of date fields? just like:

Nic Brough -Adaptavist- · Answer

Welcome to the Atlassian Community!

Could you give us example of what was in your CSV data for a couple of the rows you've show us in your screenshot?  (Feel free to redact the text fields, we only need to see the date fields