How to send webinar reminder emails 2 hours before event (with flexible date-time)

Hi,

I’m trying to build a flexible webinar system which:

  • Store the webinar date-time in a custom field names “event_date_time”
  • Use this to send reminder emails 1 day before and Zoom link 2 hours before event starts

It is easy to create a segment with the event_date_time = +1 days, to send a reminder email 1 day before. However, I have no good solution for sending the reminder email 2 hours before!

Solutions not working, creating a segment with filter:

  • event_date_time equals + 0 day + 2 hours
  • event_date_time greater than + 0 day + 2 hours + 0 minutes
  • Etc

Everything that contains hours and minutes seems to not become relative to the hours and minutes in my event_date_time custom field? I’m I doing something wrong?

Another solution I’m thinking about:

  • Creating a loop in the campaign builder that every 15 minutes checks if the date-time is 2 hours or less before the webinar date time. However, this might be resource heavy?

Do you have a better solution for how to send reminder emails dynamically 2 hours before the event?

Many thanks for reading this and trying to help me! :slight_smile: