Hi there @recirocketteam,
Welcome to the Community! Happy to help!
The possibility of doing this math between the two variables in a template is a bit complex as it will depend on how the data is passed, the data types, etc. Do you mind sending a screenshot of the event data and event properties to see how they are appearing in your template?
Please be sure not to share sensitive information in your screenshot.
Thanks for being a part of the Community!
-Taylor
Hi Taylor and thank you for your help!
So for the current year we use: {% today "%Y" as today %} {{ today }}
and for the year of the first purchase the following:
{{ person|lookup:'First Purchase Date'|default:''|format_date_string|date:'Y'}}
The output of both variables show us only the year (YYYY) of the date.
The date format of the first purchase date in the profiles is set up like this: YYYY-MM-DD
I hope this provides more clarification.:)
Hi there @recirocketteam,
Welcome to the Community! Happy to help!
The possibility of doing this math between the two variables in a template is a bit complex as it will depend on how the data is passed, the data types, etc. Do you mind sending a screenshot of the event data and event properties to see how they are appearing in your template?
Please be sure not to share sensitive information in your screenshot.
Thanks for being a part of the Community!
-Taylor
Hi @recirocketteam,
Thanks for sharing this!
There is a possibility this could work, however, as we can’t help troubleshoot custom code like this, I’d recommend reaching out to a Klaviyo partner, or better yet a Community Champion, to set this up to you!
If anyone tries this and finds a way to accomplish this, we’d love for you to share your answer below to help your peers!
-Taylor