External System Import - CSV - Unable to Parse 'Date Created' field .

[Guy Aburus]

I am attempting to import bugs from Bug Tacker to JIRA .  When I attempt the import I am successfully importing all fields except the 'Date Created' field .

I am importing from a .csv created by Excel.

I have tried a few different date or date/time formats in excel before saving the CSV file.

The issues all import except for the following field:

• Date Created  

This filed is empty after the import.

CSV file dates are formatted to m/d/yyyy h:mm (e.g 1/25/2021 7:58:00 PM)

In External System Import Date format I am changing the Date format

• from (default setting)    dd/MMM/yy h:mm a
• to  m/d/yyyy h:mm 

This filed is empty after the import.

The log shows 

Unable to parse created date: 4/8/2021 11:30
Unable to parse created date: 4/6/2021 18:26
Unable to parse created date: 4/5/2021 18:19
Unable to parse created date: 4/5/2021 12:50
Unable to parse created date: 4/4/2021 17:42

[Nic Brough -Adaptavist- · Accepted solution]

Ok, you say

"CSV file dates are formatted to m/d/yyyy h:mm"

But I doubt it.

That format is 

minute/day of month/year hour:minute

Two problems - you probably want to start with an M for month number, not an m for minute, and your h means "hour of morning/afternoon" and your dates do not contain an am/pm flag.  Either use hh for 24 hour clock or add am/pm to the CSV

[Jack Brickey]

Yes… his example CSV shows 4/5/2021 18:19 so that should be M/dd/yyyy hh:mm I think?

[Nic Brough -Adaptavist-]

Yes, I'm pretty sure h is 12 hours, and hence needs the am/pm, and hh (or H) is 24 so it doesn't anything other than a number from 0-23

[Guy Aburus]

Thanks, I managed , I changed the format cells in CSV file to m/d/yy h:mm

[Jack Brickey]

Can you try using M/d/yy h:mm in your format during import?

[Guy Aburus]

Still "Unable to parse created date .."

[Jack Brickey]

Sorry it seems you have the full year? So M/d/yyyy maybe. However if your source has “0” in day field, e.g. 4/03/2021 then it would be M/dd/yyyy…I think. I believe there is a link that The import provides for formatting?