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. 

[Andy Heinzer · Accepted solution]

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. 

[Dayananda Babu, REKHA · Accepted solution]

[John Funk]

Hi Dayananda 

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

[Dayananda Babu, REKHA]