CSV parse dates with and without time

[Veve]

I'm importing a CSV file to JIRA (Cloud) in which

• Created dates don't have a time, e.g. 2016-12-14
• But comment times do, e.g. 2017-04-23 22:14

I tried setting the Date format to

1. yyyy-MM-dd HH:mm -> Created dates are not parsed
2. yyyy-MM-dd H:mm -> Created dates are not parsed
3. yyyy-MM-dd -> times are lost from comments

Is there a good setting for the Date format or do I have to edit the CSV?

[Petter Gonçalves · Accepted solution]

Hello Veronika,

Created date is a date-time field that will affect reports and filters if not configured properly, so I recommend you to set a value in the CSV to add the time to the issues.

You can add the value 00:00 as the time.

[Veve]

Hi Petterson, 

Thanks, that's useful info indeed.