Unable to parse datetime: 23/May/23 14:11 using the date format pattern: dd/MMM/yy h:mm a

Dayananda Babu, REKHA February 20, 2024

Could you help me to overcome this error. Went through a lot of posts but not getting the right solution. 

3 answers

2 accepted

2 votes
Answer accepted
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 21, 2024

Hi @Dayananda Babu, REKHA 

Jira is using a Java class of DateTimeFormatter to manage this.  Using the

dd/MMM/yy h:mm a

convention, the 'h' value in that is only able to accept 0-12 as a value.  Hence 14 is an invalid value when you use that format.  Try this instead

dd/MMM/yy H:mm

If your times are using a 24 hour clock, then try to use the H instead of h, and then you can also drop the 'a' as you don't need to specify an AM or PM value if your values have 24 hour time format.

Dayananda Babu, REKHA February 21, 2024

Thank you. This helped. 

0 votes
Answer accepted
Dayananda Babu, REKHA February 21, 2024

Excel Date format.png

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 20, 2024

Hi Dayananda 

Can you share a screenshot of what it looks like in the CSV file? 

Dayananda Babu, REKHA February 21, 2024

Excel Date format.png

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events