I have a requirement where I have to trigger reminders to user a day prior 9 am their local time. For example, if user is from Asia/Kolkata time zone then he/she should receive the mail a day prior 9 am IST similarly if user is from Australia/Melbourne time zone he/she should receive the mail 9 am AEDT.Can someone please help with the approach?
Discussion posts and replies are publicly visible
Alternative approach, Run an hourly scheduled process that queries users whose current local time (based on stored timezone field in DB) equals 9 AM on the reminder date, then send emails to those users.Store each user's timezone in your database table.