Calculate number of days until date in email template

Question

HiWe are creating a email template to reminder customers to use their coupon / voucher. We send through a voucher expiry date as part of the event in UTC format{{ event|lookup:'Coupon Expiry }}I like to include in my email a reminder to customers to let them know they have XX days left to use their voucher based on Coupon Expiry Date - Time NowLike: Your voucher expires in 5 daysCan this be calculated as part of the email email formatting in Klaviyo?Thanks!

retention · Accepted Answer

Hi ​@jonoroy,You can try the “timeuntil” filter. Just make sure to cast your expiry date string as a date object, I’m using the “format_date_string” filter to do this. If you don’t use a specified date for the timeuntil filter, it implies that it is comparing to the time now.Roughly, this should work:{{ event|lookup:'Coupon Expiry’|format_date_string|timeuntil }}You may have to debug it a bit to make it work.

Taylor Tarpley · Answer

Hi there ​@jonoroy,Thanks for sharing your question with the Community!This should be possible, can you share what integration owns this coupon? This will inform how you configure the code to show the expiration date.Thanks for participating in the Community!-Taylor

Reply

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded