A manufactured date from Best Before date on field

Question

Hi!

I'm figuring out a consumer service solution for a client with with Jira Service Management.

Now they are looking for a solution to get the Manufactured date being calculated automatically based on the given Best Before date + a certain amount of dates given.

For example, the Best Before date was 2.3.2021 and the Manufactured Date was 2.3.2021 x 50 days.

They would like to have both these fields visible on a ticket and be able to view and filter reports based on those.

How would this be possible to execute?

Thank you for the support!

Patrick Ricciardi · Answer

@Hanna Voutilainen

I just tested it out and it worked as I suspected it would, the one hairy part I kind of had to fiddle with was how to access a custom field's smart value.

There are instructions here:

https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

Basically, I looked at the JSON and found the value for the custom field and entered it in as the variable value.

newDate

And then I added newDate to the field I needed to have it in,

So, my theory was correct and it should work for you.

Patrick Ricciardi · Answer

OH, I realized the createddate wouldn't be the same, that's just what I used to test my theory, I figured (perhaps mistakenly) it would work on a custom field.

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

This page lists the functions you can use with Date/Time

I haven't had a chance to test this out, but what if you have your automation that runs on Creation.

You call "Create variable"

Set variable name to ManufactureDateVar

Set value of variable to BestBeforeDate.minusDays(50)

Call "Edit Issue Field"

Set Manufactured Date field to your new variable {{ManufactureDateVar}}

Hanna Voutilainen · Answer

So the automation should

* Take the value from the "Best Before Date" field
* Minus lets say 50 days from that date
* Add that information into the ticket to a Manufactured Date field

I can get the automation components correct, but not the variables. :/