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
Solved! Go to 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.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
199 | |
100 | |
62 | |
59 | |
58 |
User | Count |
---|---|
254 | |
164 | |
90 | |
79 | |
70 |