Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

4 answers

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

1 vote

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.

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

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.

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

Try adding a 0 in front of single-digit days or months, like 11/04/2007.

Ok, I've been playing with it. I can get that error if my CSV contains data that is not in the right format. That's the wrong error message - it really should be saying "your data is incorrect", but I've no problems importing with dd/MM/yyyy once I correct all the data.

I need to fix the CSV file

i will add a 0 in front of single-digit days or months, like 11/04/2007.

I will come back soon

1 vote

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

Hi jeremy

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

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

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

Sağolasın Nedim.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you