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.

[Isabel LOPEZ GONZALEZ]

Hello! I am encountering a related issue. When extracting the Created field info from JIRA (for excel, live report), it appears date and hour. I need to take out the hour, because we use that in a formula that gives error if the hour appears.

Could you advise on how to do that? Thank you!