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.......
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
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....?!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.