Avatar

Correct answer by
Community Advisor

hi,

 

You can achieve this by playing with the time conversion.

Basically:

  • scheduler that will run several time (best to coincide with you time zone)
  • js activity where you will calculate (assuming your instance is EST if current hour = 10 then time= 10 and timezone=EST)
  • query using dynamic variables recipient timezone = $(vars/@timezone)
  • continuous delivery

Bonus: you can extend your delivery logs to save timezone for reporting perspective.

Thanks,

David 

View solution in original post