Forums

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

How do I convert the Original Estimate to format of end date

Eitan yomtovian
Contributor
March 25, 2018

Is there a script that does this? If so, what is and where is it written?

1 answer

0 votes
Nic Brough -Adaptavist-
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.
March 25, 2018

This is not a matter of formatting.  The data in these fields is showing you different things.

A request to "convert estimate to date format" is about the same as asking to convert between a whale and a bowl of petunias.  They are different.  It's not that you can't do it, it's that the request is complete nonsense.

The estimate is a length of time.  The date is a point in a calendar.

How would you "format" 42 hours in year/month/day/hours/minutes?  Or 29th February 1976 in hours?

Eitan yomtovian
Contributor
March 29, 2018

I will give an example,
If I put a duration of 16 hours in the mission (and a working day is defined as 8 hours), then the completion date will be two days from now - 31.3.18

Could you please explain to me how to do this?

Nic Brough -Adaptavist-
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.
March 29, 2018

Ok, that makes more sense - it's not a conversion of incompatible types, you want to work out a date given another date and a length of time.

You'll need one of the scripting or automation add-ons to do that calculation.

However, be prepared to jump through some hoops - you may need to think about weekends, holidays, etc...

Eitan yomtovian
Contributor
April 1, 2018

Okay, so where should I start?

Nic Brough -Adaptavist-
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.
April 2, 2018

Install the ScriptRunner add-on, then decide where you want to make the calculation and how you want the data to behave.  For example, do you just want to populate a field when the issue is created, and not again.  Or do you want to have it recalculated if a user changes one of the fields it is calculated from?

Eitan yomtovian
Contributor
April 2, 2018

Does the ScriptRunner supports in Jira-cloud?

Nic Brough -Adaptavist-
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.
April 2, 2018

Yes, although this simplifies your choice, as ScriptRunner for Cloud can only give you the post-functions (i.e. calculate as it goes through the flow)

Eitan yomtovian
Contributor
April 2, 2018

Okey, I install the ScriptRunner.

Can you instruct me what basic commands exist and what commands do I need to know for conversion?

Edward Greathouse October 1, 2018

Was this issue resolved? I have a similar issue, except I am hosting JIRA Server. I would like to take the creation date of an issue and calculate an "End Date" based on the Original Estimate. I want the "End Date" to change when the "Original Estimate" is updated. I believe this consists of a scripted field for "End Date"...is there anything else I am missing?

Thanks!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events