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; } } }

Please enter the date in the format "d/MMM/yy" error while importing dd/mm/yyyy

Samir Freelance

I have this error whilte trying to importing date calendar picker from csv file

An error occurred while attempting to import value '30/04/2007' into the Custom Field 'Delivery Date'.
com.atlassian.jira.issue.customfields.impl.FieldValidationException: Invalid date format. Please enter the date in the format "d/MMM/yy".

how to modify the date format of the custom calendar picker that i am using without modifying CSV and keep the format dd/mm/yyyy

or anybody have another solution please tell me how to fix this problem

Accepted answers

All comments

Nic Brough -Adaptavist-

The CSV importer specifically and clearly asks you what format you want to import dates in when you run it. Make sure you enter the correct one.

The only caveat here (which is also stated in the documentation) is that ALL your dates in the CSV must be in the same format. There is no option to have two different formats in different columns, they must be the same.

Jeremy Largman

Also, you might want to check out how to change the date format in JIRA:

http://confluence.atlassian.com/display/JIRA/__date+and+time+formats

Samir Freelance

Hi Nic

I inserted for Date format in import file: dd/MM/yyyy

and i am sure in my CSV all column have the same forma dd/MM/yyyy for all the date

still i am getting An error occurred while attempting to import value '11/4/2007' into the Custom Field 'Delivery Date'.
com.atlassian.jira.issue.customfields.impl.FieldValidationException: Invalid date format. Please enter the date in the format "d/MMM/yy".

please correct me if i am wrong 11/4/2007 should i use other than dd/MM/yyyy?

thank you for being kind

Nic Brough -Adaptavist-

I'm not sure what you mean by "import file". Can you confirm that you are entering dd/MM/yyyy into the screen that asks you for the date format when you do the import? The error message you are getting implies that you are not.

Samir Freelance

the language I am using English (United States)

i am confirming that while i am importing that i am using dd/MM/yyyy instead of the default yyyyMMddHHmmss

I am using jira-importers-plugin-2.7.5.jar to import from CSV

Samir Freelance

Hi jeremy

"date.import.format" : "dd/MM/yyyy",

is this the right format?..it is not provided in the link

flaviolimas

I had this problem and was able to save when entering the month as upper case 14/JAN/2019

Nedim Barut

I had a similar problem when I was trying to open a new ticket in Jira. After several trials and errors, I realized it was due to different language selection for Jira and my local device settings. In other words, try entering the month part in your local language, in English or any other language you may be using and that may solve the problem.

Example: When I selected the date from the date selction button, it inserted the date as follows: 25/Jan/20

Then I received the error stating the format was not correct.

I solved it by changing the month part to my local language abbreviation, which was 25/Oca/20

Umit_Celikel

Sağolasın Nedim.

Welcome!

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

Quick Links

Find more posts tagged with

jira