Jira - Bug Tracking - Create Older Issues


I just downloaded Jira to evaluate and use the same if it fits my requirements. Basically it fits most of my expectations and workflow. But i have few older projects with Issues listed in Excel, i would like to add those to Jira with the Created date as stated in excel (Which will be few months or days before). But i could not find an option to create an issue in Jira with the past dates.What ever i create by default it take current date.

Please advice how this can be done, so i can add all my older issues in Jira and see how it helps me.



2 answers

Hi Vishnu,

There's no way to modify the creation date from a JIRA issue on the interface;

I suggest you to create a Date Picker custom field called "Excel Created Date" and then, on the CSV Import process, map this custom field with the correct row on Excel.

After that you can copy via database the data from the 'Excel Creaed Date' custom field to the 'created' column on the jiraissue table (you can also do it without the custom field, but it will be easier):

jira527=# select * from jiraissue where pkey = 'MTP-1';
  id   | pkey  | project | reporter | assignee | issuetype |    summary    | description | environment | priority | resolution | issuestatus |          created           |          updated           | duedate | resolutiondate | votes | watches | timeoriginalestimate | timeestimate | timespent | workflow_id | security | fixfor | component 
 10804 | MTP-1 |   10203 | admin    | admin    | 1         | Test issue 01 | asdasdasd   |             | 3        |            | 4           | 2013-02-13 15:22:15.646-02 | 2013-03-29 15:39:31.373-03 |         |                |     0 |       1 |                      |              |           |       10813 |          |        |          
(1 row)

So, the update statement will be something like:

UPDATE jiraissue set created = (
SELECT datevalue from customfieldvalue where issue = (
SELECT id FROM jiraissue where pkey = 'MTP-1')
AND customfield = (
SELECT id FROM customfield where cfname like 'Excel Created Date')
where pkey = 'MTP-1';

('MTP-1' is the JIRA issue that I want to modify).

Just remember to perform a database backup before using this SQL.

Best regards,
Lucas Timm

Hi Lucas, just wondering... It's there any need to vote down the answer?

oh, my bad. Sorry for that.

Hi Vishnu, if I remember correctly you can configure your excel file to be a .csv and then do the import.

The first row will be the field and you can specify the column that will be created date so Jira can use that.

Have you read the documentation?


I did this to import all the issues from other software (our own software).

Thanks a TON, Lucas & Ramiro. Your inputs really helped me a lot.


Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,145 views 4 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you