How to update Target start and Target end date field via CSV import.
Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.
Summary
When you are importing a CSV file with date fields such as (created, updated etc..) along with Target start and Target end date fields the Target start and Target end fields don't get imported. Even if the format of the dates matches the format specific to the importer, these two fields won't get imported.
Environment
Jira Cloud
Cause
Target start and Target end dates are part of Advanced Roadmaps and they expect the date format to be only in “dd/MMM/yyyy”
Solution
Using the External System Import, It is possible to import the fields “Target start” and “Target end” fields only if in the CSV file we make sure that these dates are in the format “dd/MMM/yyyy” (i.e.: 16/Aug/2023) - independently from the date format which is configured in the import config file for other date fields. Regardless of how other date fields are formatted and what format you specify during import, these two fields must be in “dd/MMM/yyyy” format.