Schedule a Process Model according to different time zones

Question

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?

Shubham Aware · Answer

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.