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; } } }

Jira automation: custom field (date) + custom field (number of years) = custom field (date)

Lenka Burianova

Hi everyone,

can you help me with this one please?

I have a custom field Asset - start date, custom field Depreciation period which shows number of years of depreciation and then I have a custom field Asset - end date planned where I need the result of Asset - start date plus number of years in field Depreciation period.

Is that possible?

Many thanks!

Lenka

Accepted answers

Stefan Salzl

Hi @Lenka Burianova

I guess your choice would be

{{[date].plus[Unit]([number])}}

action: edit issue, field end date planned
update field with calculation of the smart value of your start date and add the smart value (number) of years

See the documentation:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

Please let me know if there are any further questions.

Best
Stefan

All comments

Stefan Salzl

Hi @Lenka Burianova

I guess your choice would be

{{[date].plus[Unit]([number])}}

action: edit issue, field end date planned
update field with calculation of the smart value of your start date and add the smart value (number) of years

See the documentation:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

Please let me know if there are any further questions.

Best
Stefan

Lenka Burianova

Hi Stefan,

thanks for your answer.

I am currently using this formula: {{issue.Asset - start date.plusYears(4)}}

But this is applicable only for the task where the Depreciation period is 4. But it can be a different number for every task. That is why I am looking for a solution that will add the value in the field Depreciation period to the field Asset - start date.

Something like this (I know it is not correct):

{{issue.Asset - start date}} + {{issue.Depreciation period}}

Thanks!

Stefan Salzl

You could also use the value of your "Deprication period" use as the number in the brackets. Try following:

{{issue.Asset - start date.plusYears(issue.Deprication period)}}

Stefan Salzl

I just tested the following automation rule in my system.

field "Real start" is a custom field of type date picker
field "Years of usage" is custom field of type number
field "Expected End Date" - custom field of type date picker

I just filled in Real start and years of usage --> Expected End Date was calculated and filled in by the automation rule (--> see screenshot)

Hope this helps.

Best
Stefan

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

automation

date