Created a workflow for the T-30 & T-14 emails. Have 2 queries in the workflow- first one pulls the T-30 until an event and then also anyone who bought a ticket for that event. Formula for  T-14 query: @eventdatetime >= DateOnly(DaysAgo(-14)) AND @eventdatetime < DateOnly(DaysAgo(-15)) Did the same f...