Due Date CSV Import

[Corinna Führing]

Anybody got the clue on how to format my Excel Sheet Date Format to be able to parse it in JIRA Import ? It seems a common problem and i am trying for hours now.......

[John Pfotzer]

Hi Corina,

Yes, it is a relatively simple thing to do. the secret is to keep the two (your import doc dates format and the csv files format dates the same). Normally it is dd/Mmm/yyyy to look like 06/Jan/2016.  There is a date key on the CSV process you can click on the ? or ! and it will open a dialog box to show date formats. I am going by memory on this.

welcome

John

[Corinna Führing]

am i right in understanding: a) i do not care about excel format in cells i just open csv file with editor and look at date format i see there in my lines b) than in import wizard i change the date according for 5/6/2015 (meaning 06.05.2015) i will put MM/dd/yyyy and than it should work....?!

[Corinna Führing]

5/6/2015 thats how date appears in my editor look