Hi @TheOpeningBat ,
You need the TimeZoneOffset function, which returns the difference between UTC and the user's device, for example India is +5.5 and UK is Zero (non-daylight saving) so the equation
-TimeZoneOffset(Now())/60
will get you the number of hours the user's device is ahead or behind UTC (for instance mine gives me 10 as I am in Eastern Australia Standard Time).
The below should give 8am in India
DateAdd(
Now(),
TimeZoneOffset() + 330,
Minutes
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.