nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Do a calculation

Mohamed Eid

Trying to do a sum of two values I have

The first one is start date and the second is remaining days

Both are written in Jira description custom field

However seems that they are string and cannot be added together

I ve tried to convert them to numbers but could not

So what i am looking for is to do the addition of the date and the number of days to get the expiry date and add it to the summary

Accepted answers

All comments

Vishal Biyani_2pr07j

@Mohamed Eid

Look at this link that gives you details about how to add date and number

Examples of using smart values with dates | Cloud automation Cloud | Atlassian Support

Try this out and see if it works for you

Tuncay Senturk _Snapbytes_

Hi @Mohamed Eid

Could you elaborate further on the problem you wish to solve? You have both the start date and the remaining days in the issue's description field, and you want to perform a calculation to determine the expiry date; is that correct?

The description field is a text field and can contain a lot of free-format text, which makes implementing such a scenario unreasonable. I would strongly suggest using a separate field for each and conducting the calculation accordingly.

If I am missing anything, could you provide some examples?

Mohamed Eid

So in Jira task description there is the two values as follows :

-----Q-------

Jira description :

The server xxxxx certificate is expiring in 44.9999 days,

This started at 2025-01-18 01:00:10 CET, – or 0h 0m ago.

----Unq-----

So what I want is to add 2025-01-18 01 and 44.9999 to give me the certificate expiration date which should be 2025-03-03

Tuncay Senturk _Snapbytes_

I don't believe this is the most effective way to achieve this. I mean, you need to use a regular expression to parse the entire description field, select the relevant parts, and perform the calculations. This is not particularly difficult, but it is quite error-prone. There may be other dates and time indicators; how will they be handled? Additionally, there may be weeks, hours, etc.

As I mentioned earlier, it is best to use separate fields and the appropriate field types (date, number).

Mohamed Eid

I suppose it should be simple and very reasonable

We have two pieces of info in each ticket description coming with the same format as provided the start date as YYYY-MM-DD and the remaining days until expiry

summing them gives the expiration date which we need to add to the summary

so no other dates or times its only one start date and one remaining days per ticket which gives us one expiration date that will be added to the summary which I could achieve

I could add the expiration date in the summary also i could extract both the start date and remaining days from the description and put them in smart variables but the addition/calculation does not work

could you please elaborate more or give an example to follow for the separation field you mentioned ? btw I am using jira automation rule for this

thank you

Vishal Biyani_2pr07j

@Mohamed Eid

You can create two smart variables and stored the values that you have parsed. Let's say

1. CertificateIssueDate = {{issue.description.substringAfter("This started at ").substringBefore(" ")}}

2. CertificateExpiringInDays = {{issue.description.substringAfter("is expiring in ").substringBefore(" days")}}

Now create 3rd smart variable say CertificateExpirationDate and calculate the Smart value like this

{{#debug}} {{ CertificateIssueDate.toDate("yyyy-MM-dd").plusDays(CertificateExpiringInDays.asNumber)}} {{/}}

Note: For your use case I get the value as 2025-03-03

Let me know if this helps you make progress.

Mohamed Eid

@Vishal Biyani unfortunately it didnt work

I did the following

created variable and called it startdate with the value as below :

{{issue.description.substringAfter("This started at ").substringBefore(" ")}}

then a second variable called remainingdays with the below value :

{{issue.description.substringAfter("is expiring in ").substringBefore(" days")}}

then a 3rd variable named expirationdate as :

and then used action log with this :

and it gave me this

Log action

Debug message

Log

Vishal Biyani_2pr07j

.toDate is missing

try with this corrected statement:

{{#debug}} {{ startdate.toDate("yyyy-MM-dd").plusDays(remainingdays.asNumber)}} {{/}}

Bill Sheboy

Hi @Mohamed Eid

Based on the rule images you are showing, you appear to be using Jira Server or Jira Data Center and not Jira Cloud. You may confirm that by asking your Jira Site Admin or looking at your URL: if it ends with .atlassian.net or .atlassian.com you are on Jira Cloud. Otherwise you are on Server or Data Center.

One of your Created Variables, named startdate, could be colliding with issue fields. I recommend always adding a prefix to variable names to avoid such problems, such as varStartDate.

Finally, once you confirm your Jira version, there are known problems incrementing a date / time field with a Created Variable value for Jira Data Center...even when converting text to a number. I believe the only way to solve that matches the earlier suggestion from @Tuncay Senturk _Snapbytes_ to store the value in a number field (either by extraction or from the source) and then use that number field to increment the date value.

If none of those suggestions help, please work with your Jira Site Admin to contact the Atlassian Support team for assistance: https://support.atlassian.com/contact/#/

Kind regards,
Bill

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud