How to add a time zone restriction to a future date

How To
1

Hi all,

I have a reminder like this:

{{formatDate(parseDate(floor(random * (sum(parseNumber(formatDate(now; “X”)); 259200) - sum(parseNumber(formatDate(now; “X”)); 86400) + 1)) + sum(parseNumber(formatDate(now; “X”)); 86400); “X”); “MM/DD/YYYY hh:mm A”)}}

I also have access to clients location (city, country, so the time zone).

Question: How can I make sure, that the future date that is being generated is limited to ONLY 9AM - 6PM in the clients local time zone (the day doesn’t really matter)?

Thanks for any tips or tricks!

2

According to:

https://www.make.com/en/help/functions/date---time-functions

You can set the time to any timezone. So you would need to map the city to the correct timezone. There are online tools to do that. I found this:

But there may be more.

L