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 edited

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
atlassian, out of office, loom, confluence, async collaboration, meeting recaps, remote teamwork, team alignment, knowledge sharing, AI-powered notes, productivity tools, workforce continuity, teamwork collection

Put your meeting notes on autopilot with Loom + Confluence

AI-powered meeting notes keep work moving even if you’re out of the office. Enjoy your well-deserved time off and return refreshed, confident you’ll catch up in no time.

Learn more
AUG Leaders

Atlassian Community Events