Calculate age via automation with asset value

[Mélanie ALOIRD]

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!

[Trudy Claspill]

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.

{{lookupObjects}}

{{#lookupObjects.get(0)}}{{/}} 

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

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