Calculate age via automation with asset value

Question

Hello,

I'm trying to calculate the age of a car via an automation. I was able to do it quite easily with the value of a custom field but I now need to do it with an asset value and I can't get it to work.

I used this with the customfield  : {{#=}}Round({{customfield_11421.diff(now).days}} / 365,0) {{/}}

I tried to do something similar with the asset value but can't get it to work. I tried using a variable and {{#lookupObjects.get(0)}}{{Date première mise en circulation}}{{/}} directly.

Any help is appreciated!

Mélanie ALOIRD · Answer

Hello!

Here are more details from what I tried so far :

I logged the smart value I'm trying to use, it returns the value properly :

{#lookupObjects.get(0)}}{{Date première mise en circulation}}{{/}}

Log
2024-10-07T00:00:00.0+0000
I tried a few different things to get my result :

{{#lookupObjects.get(0)}}{{Date première mise en circulation}}{{/}}.diff(now).years

Attribute value is not valid on Objects
SGAS-84472 (Age du véhicule = 2024-10-07T00:00:00.0+0000.diff(now).years)
Unable to update objects
{{#=}}Round({{{{#lookupObjects.get(0)}}{{Date première mise en circulation}}{{/}}.diff(now).days}} / 365,0) {{/}}
Unable to render smart values when executing this rule:
Improperly closed variable: {#lookupObjects.get(0) in template-02912e45-4139-4ec7-bffb-3a2ee7b83e9e:1@33: {{#=}}Round({{{{#lookupObjects.get(0)}}{{Date première mise en circulation}}{{/}}.diff(now).days}} / 365,0) {{/}}
{{#=}}Round({{#lookupObjects.get(0)}}{{Date première mise en circulation}}{{/}}.diff(now).days / 365,0) {{/}}
Unable to render smart values when executing this rule:
Unknown operator : at character position 20: Round(2024-10-02T00:00:00.0+0000.diff(now).days / 365,0)

Trudy P Claspill · Answer

Hello @Mélanie ALOIRD

Welcome to the Atlassian community.

When asking for assistance with an automation rule it will enable us to help you more effectively if you provide images showing the entire automation rule, images showing the details of any steps where you are using smart values, and images showing all the details from the audit log when you execute the rule.

Additionally consider using the Log action in your rule to print out into the audit log the values for any smart value you are using in the rule just prior to the step where you use the smart value. You can do that for the components of your compounded smart value and for the fully compounded smart value; i.e.

That will help you confirm you have valid syntax and are getting a valid value.