display current time zone suffix

(0) Share

Report

Posted on by Community Power Pla...

This formula gives the UTC time.

What I need:

I need to display in a label what exactly the time zone is?

CST

EST

GMT

PST

only: United States

Is there a way to revise the code below to display that suffix ?

"UTC"
& If(TimeZoneOffset() > 0, "-", "+")
& RoundDown(Abs(TimeZoneOffset()) / 60, 0)
& ":"
& If(Mod(Abs(TimeZoneOffset()), 60) < 10, "0", "")
& Mod(Abs(TimeZoneOffset()), 60)

Thanks

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report
Try the following instead

Switch(Text(TimeZoneOffset(Now())/60),"5","EST","6","CST","7","MST","8","PST")

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Pstork1
Thanks,
I also used:
If(TimeZoneOffset() > 0, "-", "+")
& RoundDown(Abs(TimeZoneOffset()) / 60, 0)
& ":"
& If(Mod(Abs(TimeZoneOffset()), 60) < 10, "0", "")
& Mod(Abs(TimeZoneOffset()), 60)

ON A LABEL:
f(lbl_timeutc.Text = "-6:00", "CST",
lbl_timeutc.Text = "-5:00", "EST",
lbl_timeutc.Text = "-7:00", "MST",
lbl_timeutc.Text = "-8:00", "PST",
"DONTKNOW")

Thanks
dave

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Pstork1

do you happen to know the values for Canada Time Zones ?

Dave

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

Here's a site that lists them.

Canada Time Zone Abbreviations (timetemperature.com)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Pstork1
Thank you very much.

Was this reply helpful? Yes No