Hi, I need your help with setting up my automation please.
I have a custom date field for an expiry date within the subscribers data. I would like to set up an automation so that each month, subscribers whose expiry date is passed will be unsubscribed from the sending list.
I set up a segment to define which subscribers are expired and an automation to unsubscribe users who appear in that segment.
My problem is that I can't find the way to have the segment define the date dynamically, instead of having to update the date myself each month.
I tried to use the {time} condition but it doesn't seem to work, or I can't use it correctly.
So far, I have tried :
- condition is "Acymailing field" + "name of the field" < 2025-01-13 => I get 552 users (but I would need to update the date each month)
- condition is "Acymailing field" + "name of the field" < "{time}-86400" => I get 11 users which is obviously not correct
Thank you for your help !