The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Date and Time Formatting Issues?

Jasmine Wilson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 23, 2021

I am fairly new to using JIRA. I am currently attempting to compete an import but keep getting this error message when validating the import :

 

  • Unable to parse datetime: 8/20/2021 15:04 using the date format pattern: dd/MMM/yy h:mm a

How do I fix this? 

2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

1 vote
Jack Brickey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
August 24, 2021

Note that the import use Simple Date Format here is one reference - SimpleDateFormat 

1 vote
Fabian Lim
Community Champion
August 23, 2021

Hi @Jasmine Wilson

You need to match the date formatting that you set for the import.

 Take a look at this post: https://community.atlassian.com/t5/Jira-questions/Unable-to-parse-Date-CSV-Imports/qaq-p/986038

Jasmine Wilson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 24, 2021

Thank you for your answer! Unfortunately, I am still running into this issue. How would I go about formatting a date such as this, 8/23/2021 8:38:00 AM ?

Fabian Lim
Community Champion
August 24, 2021

MM/dd/yyyy h:mm:ss a

Maciej Rygielski
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 15, 2021

You need to provide month abrivation in your national language

TAGS
AUG Leaders

Atlassian Community Events