Advanced dates in csv import

Debraj neogi October 6, 2015

Hi,

We tried a CSV import on JIRA. The problem that arises is the CSV file reads (for a comment)

24/09/2015 17:22:26 ...........

While the comment added shows a date of 09/Dec/16

 

Can anyone help on this? Not sure what is the problem. We tried the same CSV on stage, worked just fine.

 

Thanks.

1 answer

0 votes
Chris Whitten [Comskil] October 8, 2015

The / could be causing you problems. Instead try formatting your dates like this: 2012-02-10 12:30:10

It should comply with the SimpleDateformat: http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html

 

Suggest an answer

Log in or Sign up to answer