I want to build a sum of a customfield with date format and a customfield with double format (count of days).
I want to build a sum of both which should be in date format. So I only want to add value of the double formatted field to the customfield with date format.
How is this possible?
Thank you guys.
For your requirement, I would suggest using the Scripted Field. The Scripted Field can be used to perform the calculation of the Date custom field with the Number field and provide the output, i.e. the new date in date format.
You can follow the steps below to create it.
First, add two custom fields, one for the Date field and one for the Number field, as shown in the print screen below:-
Next, go to ScriptRunner's Fields option and click on the Create button as shown below:-
Once you have clicked on the create button, select the Custom Script Field as shown in the image below:-
After you have selected the Custom Script Field option, you will need to provide a Field Name for it and also select the Template to Date as shown below:-
Now, you will need to include the Script. Below is a sample script for your reference:-
def customFieldManager = ComponentAccessor.customFieldManager
def originalDate = customFieldManager.getCustomFieldObjectsByName("Original Date")
def originalDateValue = originalDate.getValue(issue) as Date
def additionalDays = customFieldManager.getCustomFieldObjectsByName("Additional Days")
def additionalDaysValue = additionalDays.getValue(issue) as Integer
return (originalDateValue + additionalDaysValue) as Date
Please note, this sample script is not 100% exact to your environment. Hence, you will need to make the required modifications.
Below is a print screen of the Scripted Field with the code:-
After adding the code, you can save it.
Below are some print screens of a test:-
For this example, the Original Date selected is 14th May 2021 and the Additional days entered are 7, so the expected result in the Scripted Field is 21st May 2021.
In the print screen above, the Updated Date, i.e. the Scripted Field, is set to 21st May 2021 as expected.
I hope this helps to answer your question. :)
Thank you and Kind regards,
Hi @Ram Kumar Aravindakshan _Adaptavist_
thanks for your reply.
This looks really good for calculating with days.
In my case I had to calculate with months and I also want to share my source code with you.
def cfIntervall = ComponentAccessor.customFieldManager.getCustomFieldObject(13022)
def cfFreigabe = ComponentAccessor.customFieldManager.getCustomFieldObject(15024)
if (cfIntervall && cfFreigabe && issue.getCustomFieldValue(cfIntervall) && issue.getCustomFieldValue(cfFreigabe))
def intMonths = issue.getCustomFieldValue(cfIntervall) as Integer;
def newRevision=DateUtils.addMonths((Date) cfFreigabe.getValue(issue),intMonths)
Maybe someone has the same problem like me.
But thank you for your reply, works also.
Since our last roundup in April, Atlassian's Marketplace Partners have added over 100 new cloud apps to the Atlassian Marketplace to help your teams work more efficiently. Let’s take a quick look a...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events