Import Issue in CSV format with Target Start and Target Finish date

[Alfred Tan]

Hi, 

The Target Start and Target Finish date format is d/MMM/yy. 

However, in Excel, when converting to d/MMM/yy, for September, in CSV file, it shows Sept instead of Sep. 

This has caused all my September tasks not able to import into the Jira. 

Please help if you know the trick. 

Thanks in advance. 

Regards,

Alfred Tan

[Carlos Garcia Navarro]

Hi @Alfred Tan 

This issue may be related to the system locale settings of your MS Excel application. If the locale is set to British or Australian English the abbreviation for September is "Sept" instead of "Sep".

Could you please check your configuration and change the locale to US English?
 Another solution could be to use the Excel formula LEFT(string, number)" to convert "Sept" to "Sep".