Hi
I'm creating automation where date value come from Assets and date format is in variable
End date: {{object."End date"}}
Now i have in Assets another field ( {{object."Renewal date notice period (calendar days)"}}) where is stored days in number format what is needed to calc off from "End date"
So i log both into audit log.
Renewal date: {{object."Renewal date notice period (calendar days)"}}
End date convert value {{object."End date".format("dd/MM/yyyy")}} and i just did to test that maybe date format is wrong.
So when i write in .minusDays(30) this calc works and it shows from orginal date 30 days off but how to write it with value what come from assets and today it is 30 but tomorrow it is 180?
End Date minus Renewal Date: {{EndDateminusRenewalDate}}
{{object."End date".minusDays(30).format("dd/MM/yyyy")}}

In log side it seems to be nice:

Idea is that orginal date is 23.01.2026 then in renewal date notice period (calendar days) say how many days have to take off and then automation will send e-mail.