I am currently constructing a query that will add people into a data extension when their event_date is 28, 21, 14 or 7 days away. I currently use
WHERE hasMadeApplication = 'False'
AND [Event_StartDate] >= DateAdd(day,28,cast(GetDate() as date))
AND [Event_StartDate] < DateAdd(day,29,cast(GetDate() as date))
to get those 28 days away, but how would I write the rest of it to add those people 21 or 14 days away? I'm not sure whereabouts the 'ORs' and 'ANDs' need to go. I have tried
WHERE hasMadeApplication = 'False'
AND [Event_StartDate] >= DateAdd(day,28,cast(GetDate() as date))
AND [Event_StartDate] < DateAdd(day,29,cast(GetDate() as date))
OR WHERE hasMadeApplication = 'False'
AND [Event_StartDate] >= DateAdd(day,21,cast(GetDate() as date))
AND [Event_StartDate] < DateAdd(day,22,cast(GetDate() as date))
OR WHERE hasMadeApplication = 'False'
AND [Event_StartDate] >= DateAdd(day,14,cast(GetDate() as date))
AND [Event_StartDate] < DateAdd(day,15,cast(GetDate() as date))
But that doesn't transfer any records. Clearly my syntax is wrong somewhere.