Show time for a country

[Mo_Islam]

Hi,

How can I show time for a specific country if I know which UTC value to show.

e.g. I want to show the time based on UTC - 1 hour

I currently have a clock which shows Now(), but I want to change this based on UTC.

Thank you

[v-xiaochen-msft · Accepted solution]

Hi @Mo_Islam ,

According to your description, the point is the TimeZoneOffset () function and the DateAdd() function.

I've made a test for your reference:

1\ Add a label control and set its Text property to:

Now()           // This is local time.

2\ Add a label control and set its Text property to:

DateAdd(Now(),TimeZoneOffset(Now()),Minutes)   // This is UTC time.

3\ Add a label control and set its Text property to:

DateAdd( DateAdd(Now(),TimeZoneOffset(Now()),Minutes),-1,Hours)  // This is UTC time – 1 hour

4\ The result is as follows:

Best Regards,

Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.