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.