I am getting the below error when importing CSV file into Jira. * Issue can't be created due to the error/s [ fields.validation.date.format; fields.validation.date.format ] Here is my CSV file date format: Here is the date format i chose during the import Any guidance or assistance greatly appreciated. thanks

it seems that i don't have access to jira/settings/issues/fields. I may need to reach out to our Jira support team. But thank you.

It would be helpful if you could tell us the Type of the destination project and the actual field type for these fields. Then we can try to recreate your scenario to make sure that we give you advice that we can first prove works. If the destination is a Company Managed project you need to go to /jira/settings/issues/fields Find each of the fields and tell us what it says for Field Type. If the destination is a Team Managed project you need to go to the Project Settings for that project to get the field type. The format suggests that it might be a date/time field.

so i did an export of some of the project records with some target date data and I see the target date field as "Custom field (Target Date)" on the export excel file and the exported date has the following date format "9/26/2025 12:00:00 AM". I hope this helps shade some light:) Thanks

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira import date format error

Haile, Eskinder

I am getting the below error when importing CSV file into Jira.

Issue can't be created due to the error/s [ fields.validation.date.format; fields.validation.date.format ]

Here is my CSV file date format:

Here is the date format i chose during the import

Any guidance or assistance greatly appreciated.

thanks

Accepted answers

All comments

Trudy P Claspill

Hello @Haile, Eskinder

The format you chose is day/month/year, but the data on you file is apparently month/day/year.

Try MM/dd/yy

Haile, Eskinder

Thanks for the response! That was bad on me:)

I just tried it with MM/dd/yy and i am still getting the same error. But I will double check in the morning to make sure I am not doing something wrong.

Thanks

Trudy P Claspill

Are you trying to import data to an existing Jira project?

Can you confirm for us the field types in Jira for the two date fields you are trying to populate?

Can you show us a sample of the raw CSV file text showing data in those two fields?

Yogesh Mude_f9cg0f

@Haile, Eskinder Also, dont try to change the jira date format while importing based on your CSV file. instead, try to match date format of your CSV file with the Jira date format.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud