Using smart values to set the date with some math operations

[Arne Henrichsen]

Hi,

I am trying to set the start date field based on some other parameter:

{{now.withYear(2024).withMonth(1).withDayOfMonth(15).plusDays(issue.Start PI)}}

The above works great, but I would like to have the following calculated inside the plusDays function:

(issue.Start PI - 3)

I have tried various variants, but nothing seems to work:

{{now.withYear(2024).withMonth(1).withDayOfMonth(15).plusDays({{#=}}{{issue.Start PI}} - 3{{/}})}}

or

{{#=}}now.withYear(2024).withMonth(1).withDayOfMonth(15).plusDays(issue.Start PI -3){{/}}

Any idea how to do this?

Thanks in advance

Arne

[Arne Henrichsen · Accepted solution]

Ok, I never saw in the documentation the minus function, so the following solved my problem without creating another variable;

{{now.withYear(2024).withMonth(1).withDayOfMonth(15).plusDays(issue.Start PI.minus(3))}}

[Arne Henrichsen]

Hi Jovin,

I was looking for something like that, but did not find any info on that. Could you point me to some examples? 

[Arne Henrichsen]

Just found the CreateVariable action, I will try it now.

[Jovin]

Hey @Arne Henrichsen

Have you tried using "Create Variable" action before and performing the "{{issue.Start PI}} - 3" in that action?

Then you can refer to the variable as a number by then going {{smartValue.asNumber}} in the .plusDays?

[Arne Henrichsen]

I have create a variable called daysOffset, but it is still not working:

{{now.withYear(2024).withMonth(1).withDayOfMonth(15).plusDays({{daysOffset}})}}

or

{{now.withYear(2024).withMonth(1).withDayOfMonth(15).plusDays(daysOffset)}}

On its own, {{daysOffset}} shows the correct number.