Forums

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

select date and add 60 days in that date to calculate date for different field

Preeti Yadav July 13, 2022

I have custom field "A" which is of type Date Picker.

And need to calculate date for field "B" by adding 60days in date which we have selected for field "A"

So, field "B"= "A" + 60 Days , calculated date should be seen in Field "B" automatically.

How to do this?

2 answers

0 votes
Vincent Mutambuki { Mumo Systems }
Contributor
July 14, 2022

I agree you can use automation to do the calculation. If you want an even simpler way, you can use Abacus

Bill Sheboy
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.
July 14, 2022

Hi @Vincent Mutambuki { Mumo Systems } 

When recommending a marketplace vendor product, please ensure that you disclose your affiliation to that vendor in your post wording. For more information about this, please see:

Atlassian Community online guidelines for Marketplace and Solution Partners

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Atlassian-Community-online-guidelines-for-Marketplace-and/ba-p/689723

Kind regards,
Bill

Vincent Mutambuki { Mumo Systems }
Contributor
July 14, 2022

@Bill Sheboy Also agree. That is why the name of our company is in my name. That way the user can derive the connection. 

0 votes
Bill Sheboy
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.
July 13, 2022

Hi @Preeti Yadav 

I believe you can do this with an automation for Jira rule, or with one of the scripting/calculated fields addons from the marketplace.

Kind regards,
Bill

Preeti Yadav July 14, 2022

Hi @Bill Sheboy ,

Can I have some sample script for this?

Bill Sheboy
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.
July 14, 2022

I am not using any of the scripting addons, so perhaps someone else in the community can comment on that approach.

For an automation rule, you could trigger on the issue create, or change of the field "A" value, and then set the field "B" using the built-in date increment functions: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/  If you want to try using the automation rule addon...

To get you started on creating your rule, please review this documentation and examples:

Suggest an answer

Log in or Sign up to answer