Date parsing issue while migrating data from CSV to Jira Cloud

[Joby John]

• Unable to parse datetime: 09/21/2022 using the date format pattern: MM/dd/yyyy HH:mm aa

How do I fix this issue? I have the following values in csv file. 

csv

12/01/2022 

12/03/2022 12:00 AM

I need help with using the right convention of date format to support the dates with and without timestamps.

[Walter Buggenhout]

Hi @Joby John and welcome to the Community,

I would suggest to update the dates in your csv file, so you have a consistent input format when you start your import. The import configuration only lets you specify 1 single format, so make sure the data you are feeding to the processing engine is consistent with that format.

Hope this helps!