I am writing a query that will add people into the data extension if the event is starting in 1 week time. So the idea is to trigger the reminder email 1 week before the event.
The snippet of query is below:
Select * where start_date = DATEPART(dd, DATEADD(dd,-7,GETDATE()))
The query works fine. But the issue is I need to add 10 hours to offset the US server time so that it will match my local time.
For other date related qeuires I have been doing this
start_date = DATEPART(dd, DATEADD(hh,10,GETDATE()))
How can I combine these two so that I can add the people 7 days before the event into DE and also consider the time difference?