@bbsin
From what I see here, there is no daylight savings time in Kuala Lumpur, which means it will always be UTC + 8hrs.
https://www.timeanddate.com/time/change/malaysia/kuala-lumpur
Therefore, the following should give you KL time.
DateAdd(
DateAdd( Now(), TimeZoneOffset(), Minutes),
8,
Hours
)
For your example here, you can use the following formula:
With({klTime:
DateAdd(
DateAdd( Now(), TimeZoneOffset(), Minutes),
8,
Hours
)},
"<div style ='text-align: right; font-size:100px; color: white; text-shadow: 2px 2px 4px #black; '>" & Text(klTime, "[$-en-US]hh:mm") & "<font size = '80'>" & Text(klTime, "[$-en-US]:ss") & "</div>"
)
