# Date in original estimated time by other date measure

**URL:** <https://community.eazybi.com/t/date-in-original-estimated-time-by-other-date-measure/445>\
**Category:** Questions & Answers\
**Tags:** javascript\
**Created:** [April 5, 2018, 7:09am UTC](https://community.eazybi.com/t/date-in-original-estimated-time-by-other-date-measure/445 "2018-04-05T07:09:08Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![daina.tupule](https://community.eazybi.com/user_avatar/community.eazybi.com/daina.tupule/32/8838_2.png) [@daina.tupule](https://community.eazybi.com/u/daina.tupule)\
**Post date:** [April 16, 2018, 8:01am UTC](https://community.eazybi.com/t/date-in-original-estimated-time-by-other-date-measure/445/2 "2018-04-16T08:01:47Z")

</div>

Hi Jose Maria

Measure **Original estimate hours** are related to issue creation date only. If you need to retrieve Original estimated hours with any other date, you can create a new custom field measure with JavaScript code. This measure will automatically be related to all default dates and any other [date you are importing into eazyBI as a measure](https://docs.eazybi.com/display/EAZYBIJIRA/Custom+Fields#CustomFields-Measureswithcustomdatefields).

Here is a [JavaScript custom field](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/javascript-calculated-custom-fields) definition for **Original estimated hours** :

```auto
[jira.customfield_oe]
name = "Original estimated hours"
data_type = "decimal"
measure = true
javascript_code = '''
if (issue.fields.timeoriginalestimate) {
timeoriginalestimate = issue.fields.timeoriginalestimate / 3600.0;
issue.fields.customfield_oe = timeoriginalestimate;
}
'''

```

Please add the custom field definition to [eazyBI advanced settings](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/advanced-settings-for-custom-fields) or ask Jira administrator to do this for you, as only Jira administrators, has access to eazyBI advanced settings.

Open [Jira import settings for edit](https://docs.eazybi.com/display/EAZYBIJIRA/Jira+Issues+Import#JiraIssuesImport-Editimportparameters) after changes in advanced settings and select the custom field for import as a measure and as a property and run an import. Import will create new measures with any date ( **Original estimated hours with due date** , **Original estimated hours with _custom date_** , etc.) and property **Issue Original estimated hours** in your account.

Daina/ [support@eazybi.com](mailto:support@eazybi.com)

---

_[View the full topic](https://community.eazybi.com/t/date-in-original-estimated-time-by-other-date-measure/445)._