Import Error: Please enter the date in the format "d/MMM/yy", eg. "14/Sep/16"

LongN September 13, 2016

As screenshot below, I have my data format mapping with mask but when I do the validate, JIRA told me that it's wrong sad 

 

2016-09-14 14_35_19-External System Import - FI2.0.png2016-09-14 14_32_49-External System Import - FI2.0.png

2016-09-14 14_32_51-E__1_working_BPO_task_BPO_Task_import.tsv - Notepad++.png

2 answers

0 votes
Brian Longstreet February 28, 2021

You might check the similar issue: https://community.atlassian.com/t5/Jira-questions/dates-on-csv-import/qaq-p/251637

When importing, and your Jira format is: dd/MMM/yy h:mm a  

from an excel csv file, use custom format: dd/mmm/yy h:mm AM/PM

Right click and select cell formatting. Click on Custom. Select any date configuration, then manually enter in the custom format above into 'Type'. You should be able to import fine afterwards.

 

Upload Screenshot.JPG

0 votes
LongN September 14, 2016

It's always got error with TODAY() but if I set due date from tomorrow to future, error gone sad 

but in my project, i have a lot of task create at the morning and due on today() need imported 

Suggest an answer

Log in or Sign up to answer