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

[Trudy 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 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]

@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.

[Haile_ Eskinder]

@Trudy Claspill Yes, I am trying to import data to an existing project. 

Here is a sample data on the csv file:

Issue ID

Acceptance Criteria

Summary

Parent

Assigne

Description

comments

Label

Agile Team

Status

TargetStart

TargetEndDate

1

TBD

some summery here

PORT-1111

Myself

Project Description

Comments

Some label

IT Team

In Progress

TBD

some summery here

1

Myself

Project Description

Comments

IT Team

Done

TBD

some summery here

1

Myself

Project Description

Comments

IT Team

Done

3/24/2025

3/28/2025

TBD

some summery here

1

Myself

Project Description

Comments

IT Team

Done

2/24/2025

3/7/2025

[Trudy Claspill]

Thank you for that additional information.

What is the Type of the project into which you are trying to import the data? Get that information from the projects list available from Projects > More Projects > View All Projects.

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

[Haile_ Eskinder]

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

[Trudy Claspill]

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 

<yourBaseUrl>/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.

[Haile_ Eskinder]

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.