Microsoft's Canada timezone troubles leave admins fixing calendars

36 pointsposted 3 hours ago
by canucker2016

29 Comments

IsaacAzuelos

2 hours ago

Albertan here. The problem wasn't just rolling out the changes (and needing staff to actually install updates and restart).

Even if you update your Windows settings to say the new correct time zone, it still doesn't go back and update the time zone that future Outlook meetings are scheduled for.

I noticed that my personal calendar on my phone seemed fine, and iOS seems to book meetings based on a TZ identifier (America/Edmonton) rather than offset or a name like 'Mountain Time.' That system seems to have worked well in this case.

It's tricky, do you want future meetings to follow the city they're in, or do you want past meetings to properly track when they happened across zone redefinition (and what even is correct)? There's no simple way to get this right everywhere.

I still think the path Outlook took wasn't ideal for the majority of their customers in the effected places though.

Symbiote

2 hours ago

If someone in Alberta discussed a meeting with someone in Britain "let's say 12:00 London time" and the Albertan recorded that as 05:00 in their own calendar, then how can the software know that this should now be 06:00?

The Albertan could have set the time to 12:00 in Europe/London, but probably few people do this unless they're expecting to travel to the other place.

tetraodonpuffer

an hour ago

it seems an unsolvable problem either way, the meeting is "at 12:00 london"

1. the London person owns it, schedules in local (London) time 12:00

2. the London person owns it, schedules mental math explicit Alberta time 05:00

3. the Alberta person owns it, schedules in local (Alberta) mental math time 05:00

4. the Alberta person owns it, schedules in explicit London time 12:00

You cannot get all of these working by software only no matter what you do, because there "mental math" time cannot take into account the implicit expectations, 1 and 4 will be correct as stated (the meeting is at 12 London time) but 2 and 3 what do you do? How would you differentiate between "mental math what I thought Alberta time was" vs "I really meant it at this Alberta time"

subarctic

2 hours ago

> It's tricky, do you want future meetings to follow the city they're in, or do you want past meetings to properly track when they happened across zone redefinition (and what even is correct)? There's no simple way to get this right everywhere.

I thought using the city (America/Edmonton or America/Vancouver) does both of these though?

freeone3000

2 hours ago

Using city name references (alberta/edmonton) rather than Mountain Time is correct in all cases.

doorpheus

2 hours ago

Its not that hard to get right. I'm a software dev working in Vancouver and our team was able to track all our timezone dependencies and account for the new offset. The Microsoft team definitely has some organizational issues since they've had 7ish months to fix this.

rjrjrjrj

26 minutes ago

Describing it simply as "the new offset" seems like an oversimplification.

Just in BC there were multiple changes, some of which (eg Eastern Kootenays) were decided much more recently than 7 months ago. The MSTNO area didn't change, but in not changing its offset relative to the rest of the province did.

Displaying historical data, ranges that include the moment that the new definitions come into effect, temporal and/or spatial aggregations that span multiple timezone definitions... lots of tricky things can pop up.

That's not to excuse Microsoft. This isn't the first timezone change that has happened, and they should have the most robust change management process in the world for stuff like this.

barbazoo

an hour ago

We have Yoto devices for our kids and they haven't updated either, their America/Vancouver timezone fell back an hour last weekend. There is no UTC-7 or the proper Pacific time timezone. Frustrating, this was known for so long.

Shank

2 hours ago

I'm genuinely curious as to how fast this was handled by Apple devices, Linux, etc. With enough advance notice, I don't see this being that terrible to patch. Was it lack of advance notice?

bryanlarsen

2 hours ago

Date decision announced:

BC: March 2 Alberta: April 20 Manitoba: Sep 17 Western Ontario: Oct 13

Manitoba didn't give much advance warning. Western Ontario is on the same time zone as Manitoba so it was very confusing there until at the last second it was clarified. So Microsoft has an excuse for screwing up Kenora. Vancouver though should not have been a problem.

Marsymars

2 hours ago

I'm in AB and work at a Windows/MS-based shop, and haven't run into any real problems with any Windows/Apple/Linux systems with the time change.

Our IT department ran a couple scripts last week and everything this week has been smooth sailing.

Things I have run into problems with have been my smart thermostat (ecobee, now fixed), my Philips Hue lights (most of my automations are via Home Assistant, but I have a handful that rely on colour temp in the Hue app), and my Ford car. (Auto time zone and auto time aren't separately configurable, and auto time zone puts me in the wrong time zone.)

teunispeters

an hour ago

No issue at all for Manitoba time (or Saskatchewan time) on Linux devices. Teams in a browser (Linux) failed though, badly - so this is a systemic Microsoft problem.

itslennysfault

2 hours ago

The OS knows how to handle all sorts of weird timezones without issue. On mac it's just a matter of updating the files in /usr/share/zoneinfo/

No idea what Microsoft is doing.

gerikson

2 hours ago

The TZ db team have been aware of this since the first announcement in BC.

That said, operating systems need to get the correct files in place.

Edit here's the TZ Announce list. Note that Cuba's very recent decision not to leave DST is included.

byte_0

2 hours ago

I am also curious to know if having the system clock in UTC and storing times using UTC, which I understand UNIX-based operating systems do, avoids these types of issues. It should make them easier to manage, is my guess.

teddyh

an hour ago

For past events, you can certainly store them as UTC and (possibly implied) location, provided that you also have a historically accurate database of all past time zone changes, so that you do not report that a meeting took place at 9:00 when it actually happened at 10:00, but the current time zone rules (at that location) are not the same today as they were on that date in the past.

For future events, you have to store them as location + timezone-naive dates and times, a.k.a. local time. Since if a meeting at a certain location is scheduled at 9:00, which is currently at 02:00 UTC, and then a timezone change happens, and UTC 2 suddenly means 10:00 at that same future date and location, the meeting will still happen at 9:00 local time. You cannot store future events as UTC only.

toast0

2 hours ago

That's not a major factor in this, afaik.

A) you need the new timezone definition available and pushed everywhere regardless. It doesn't matter what zone the RTC uses.

B) For future events, you need a way to manage what happens when the time zone they're scheduled in changes OR when they change to a new time zone. Microsoft has been terrible at this part on every time zone change I've been aware of (it's hard, but it's not this hard, and the Canadian change was published with sufficient notice, and time zone changes happen for recurring events, this is not a new requirement). But there's no connection to the time zone of the RTC here either.

If you have issues with poor behavior specifically around transitions, that could be related... Repeatedly moving forward or backward for DST is something where keeping the RTC in UTC would help.

kayodelycaon

2 hours ago

UTC brings its own batch of problems when it comes to local time relative scenarios.

Last time I looked best practice for a real calendar app was to store in local time with time zone, not UTC with offset.

UTC is time in theory. Points in time separated by numbers of seconds. Great until the reality of time being a social construct breaks your assumptions. Still, use UTC until you are actually building a calendar app. Depending on your use case, consider storing timezone instead of offset.

JTbane

an hour ago

That's interesting because I work in industrial data and pretty much everything is stored and logged as UTC to avoid these kinds of mess ups.

  best practice for a real calendar app was to store in local time with time zone, not UTC with offset

notatoad

2 hours ago

my experience on apple devices in alberta hasn't been any better, microsoft is just the bigger target for articles like this because more people use it for scheduling meetings.

it took around 40hrs for my apple watch and my iPhone to start agreeing on what time it was.

yipinwong

2 hours ago

That stupid "special" timezones in Canada messed up Microsoft (they got their issues for not keeping their record stragith).

This is what happens when a part of country does not follow. China is the other extreme. They got one stupid timezone, so one part of the country is dark AF, but then other side is daylight.

This all comes down to whoever is running the government.

US should also abolish stupid daylight savings, but northern politicians do not want while there is bipartisan agreement to make the savings time permenant.

tzs

13 minutes ago

> US should also abolish stupid daylight savings, but northern politicians do not want while there is bipartisan agreement to make the savings time permenant.

That bipartisan agreement will evaporate after the first winter on permanent DST and either DST will come back or we'll switch to permanent standard time. That's what usually happens when people try permanent DST.

mthoms

an hour ago

That's a whole lot of stupid!

- Regional time zones? Stupid.

- One time zone for the entire nation? Stupid.

- Daylight Savings Time? Stupid.

- When Western Canada gets rid of DST? You guessed it... stupid!

Everything is stupid!

yipinwong

18 minutes ago

i call dumb sh*ts dumb and what's the issue?

Did i say everythign is stupid? No. I only showed the part of the issues.

You went down the slippery slope went extreme.

tosti

an hour ago

Let's get rid of time!

yipinwong

18 minutes ago

even more extreme slippery slope. you are like the one who say get rid of cars because they kill people.