The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

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

CSV Import Comment date not coming in correct.

Jenifer Kuntz
Contributor
July 31, 2015

This is the format I have in my CSV file - 7/29/2015 11:40;admin; This is my comment

I have entered the date format as mm/dd/yyyy h:mm  and m/d/yyyy h:mm

and this is what I end up with.  

29/Jan/15 11:40 AM

I changed the date to 10/29/2015 and still get January.  I had three other date July 28th and July 10th the day always populates correct and month is January.  What am I missing?

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote
Answer accepted
Stefan Ernst
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 Champions.
August 1, 2015

Are you importing worklogs? Because this will ignore the date format settings entered at the beginning of the import process and instead fall back to Jiras default settings. I ran into this in JIRA 6.3.13 and adjusted my CSV accordingly

Jenifer Kuntz
Contributor
August 3, 2015

No, I am just importing the comments at this point.  I just find it really odd that it gets the day year and time correct but has the wrong month.

Stefan Ernst
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 Champions.
August 3, 2015

maybe the problem is with upper / lowercase "m"? Because m is minutes and M is month. Also shouldnt it be MM for the month, not only M?

Jenifer Kuntz
Contributor
August 12, 2015

It was the lower case! Thank you.