Automation in assets

Question

Hello community,

I want to create an automation in Assets, specifically: I have two date fields (Last Check and Next Check), and I want that if a date is entered in the Last Check field, the Next Check field automatically updates to +90 days based on the date in Last Check.

The problem is that the automation step "Then and Attribute Value and Value:" does not work with ${Last Check.plusDays(90)}.
But with a fixed date like 2025-10-15 or just ${Last Check}, it works fine.

As I understand it, my Assets instance does not support plusDays(90).

In the logs, it shows the error:
rlabs-insight-attribute-3401: At least one value must be set;

Is there an alternative to ${Last Check.plusDays(90)}?

P.S. My instance is Data Center.

Petru Negrusa · Answer

@Trudy P Claspill 
Our version JSM - 5.12.24, JS - 9.12.24 and ScriptRunner - 8.34.0

Trudy P Claspill · Answer

I see you are attempting to use the Automation feature within Assets.

Are you aware that with ScriptRunner you also get some functions for accessing Asset objects in Jira's Automation for Jira feature?

https://docs.adaptavist.com/sr4js/9.7.0/integrations/automation-for-jira

What version of Jira Data Center are you using, and what version of ScriptRunner?

I don't believe it is possible to use date functions with the Date or Date/Time attributes in Assets because the date in DC Assets are stored a epoch dates.

I believe you will have to use groovy scripting to calculate a new date with that in mind, either

1. converting the stored date to a date/time variable, using date functions, and then converting it back to an epoch date to set the attribute, or

2. doing the calculation without converting the epoch date and without using date functions.

Petru Negrusa · Answer

Hi @Trudy P Claspill 
Thank you for your message.
I attached 3 attachments where you can see the fields and the automation.
I would like to add that I also added other values in the automation (${Last Check.plusDays(90).format("yyyy-MM-dd")})  and ${Last Check.parseDate("dd/MM/yyyy").plusDays(90).format("yyyy-MM-dd")}
But without any result.