CSV exported issues don't show AM, PM in Date/Time field
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Summary
When Jira issues are exported from Jira, the exported file doesn't show AM/PM in a Date/Time custom field nor the time is in 24hr format. To know more about exporting Jira issues, refer to Export search results
From Request From CSV
Environment
Jira Cloud
Cause
Complete Date/Time Format is not as per the required format.
Solution
The exported values of the date/time field are controlled by the Complete Date/Time Format in the Look and Feel (https://<Site-name>/secure/admin/LookAndFeel!default.jspa) section of Jira cloud instance.
Follow the below steps to add the am/pm marker:
Navigate to Settings > USER INTERFACE > Look and Feel
Scroll down to the Date / time formats section
Click the value of Complete Date/Time Format, add "a" at the end of the value as shown in the below image
Click Update
Retry the export action
Refer to the following documentation: Change date and time formats and Java SimpleDateFormat
Was this helpful?