Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

csv import with wrong creation year

David Shapiro
Contributor
August 28, 2012

Morning,

Transfering issues from an old system to Jira brought one over accidently with a creation date of Sept 6, 2013 instead of Sept 6, 2012. Is there a way to change the date?

1 answer

0 votes
Norman Abramovitz
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 28, 2012

The easiest is to update the database directly.

1) Stop Jira

2) Verify Jira is not running

3) Verify that the database field has your incorrect value is the table mentioned below. If not, then stop there and ask for help again else use SQL to update the create date field.

https://developer.atlassian.com/display/JIRADEV/Database+Schema#DatabaseSchema-IssueFields

4) Restart Jira

I cannot stress more that you need to stop Jira before modifying the database directly.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events