Forums

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

Date format error when JSON import

Ian Carlos
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 Leaders.
November 23, 2022

Hi guys, hope you're all fine

I'm importing some issues into JIRA (a lot of them, thousands) which one customfield is datetype with the format "dd/MMM/yy h:mm a"

I have already fix my dates when importing, but, the midnight hours are giving me problems

Only those hours, they return this error (is in spanish, but it says that the format is not the correct one)

date_issue.png

I don't understand why it says that, is the same format, and works for other ones like this:

date_good.png

Anyone has a clue on this? I would really appreciatte any help

 

Thank you for your time

1 answer

1 accepted

2 votes
Answer accepted
Sunny Ape
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 Leaders.
November 23, 2022

Hello @Ian Carlos 

If you use the am/pm suffix, you need to submit the time part as '12:56 am' instead of '0:56 am'

If you omit the am/pm suffix, just submit it in 24hr format '00:56' (HH:mm)

Ian Carlos
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 Leaders.
November 23, 2022

Yeah, it was that, the "12:XX", I forgot that I was using 12 hours format and doesn't exist the 00:00 hours in it

 

Thanks!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events