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

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

Dayananda Babu, REKHA

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

Accepted answers

Dayananda Babu, REKHA

Excel Date format.png

Andy Heinzer

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.

All comments

John Funk

Hi Dayananda

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

Dayananda Babu, REKHA

Excel Date format.png

Dayananda Babu, REKHA

Excel Date format.png

Andy Heinzer

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

Thank you. This helped.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud