Import ics to Office 365 Calendar but the event time is wrong.

Hi Joe,

Do you receive the .ics file I've sent to you?

Thanks,

Lance

Hi Lance,

Thanks for your help. I have checked the .ics file you sent to me, but I think it doesn't solve my problem because of the following two reasons.

Reason 1.

I get another problem when I use your test .ics file to describe an event at "Sun 4/14/1991 8:00~8:30" in Shanghai.

Shanghai had observed daylight saving time during 1986~1991, so it's in CDT time zone (UTC+9) at 4/14/1991~4/15/1991. [1]

Therefore, the date time "Sun 4/14/1991 8:00" in Shanghai should be as same as the date time "Sat 4/13/1991 23:00" in UTC time zone. [2]

However, after I import a new .ics file which is followed by your test file, the server shows this event is at "Sun 4/14 1991 00:00" in UTC time zone.

It's a wrong date time!

Reason 2.

The only different between your file and mine is that there are some Standard/Daylight Time rules to describe the time zone change during 1986~1991 in my .ics file.

However, those rules should NOT effect the events which are in 2018.

Besides, the Google Calendar can show the event information correctly after I import the same .ics file.

I seriously doubt that there are some bugs of your .ics parser.

I hope your RD team can check this issue.

Thanks.

[1] Time Changes in Shanghai https://www.timeanddate.com/time/zone/china/shanghai

[2] Time Zone Converter https://www.timeanddate.com/worldclock/converter.html?iso=19910413T230000&p1=237&p2=1440

Hi Lance,

Sorry for your misunderstanding. The ics file is written by myself after I read the iCalendar spec document (RFC 5545).

I didn't find anywhere can update my Office 365 web app. Do you know how to update those app?

After I import the file, OWA shows the timezone in my default display timezone (UTC+8), and as same as Google Calendar.

However, OWA shows the incorrect event time: 6:00a~7:00a in UTC+8, but Google Calendar shows the correct event time: 7:00a~8:00a in UTC+8.

Thanks.

Hi Joe,

Thanks for your notification. I've read the post again.

I notice that there is a value 'Microsoft Exchange Server' in the ics file, so I'd like to confirm if this file is exported from the calendar on your local Exchange server. Meanwhile, please let me know the current Exchange environment. Do you use Exchange hybrid?

If you are able to update your Office 365 web app, please update it and verify the result.

As this file shows correctly Gmail, we can conclude that the file might be ok. The issue may occur when the file is imported to OWA.

Did you confirm if the timezone is the same as OWA?

Thanks,

Lance

Hi Lance,

I don't have the permission to download Outlook in my PC. I can only use Outlook web app (Office 365).

Do I need to update my Office 365 web app before I import ics file?

By the way, I simplify the problem and edit the original post.

I have checked the RFC 5545 document (iCalendar Spec.), and it seems nothing wrong in my ics file.

Besides, this ics file can be shown correctly in Google Calendar, but Office 365 Calendar can't.

Is it a bug of Office 365 Calendar?

Thanks.

Hi Joe,

Please check if the ics file and the time zone is correct in Outlook. If the time code is correct, please set the time zone for the event to UTC+0 and import the ics file again to verify the result.

Meanwhile, I'd like to confirm if you've installed the latest update for all the Office apps. You can go to File > Office Account > Update Options > Update Now in Outlook to check for updates. If the version of Outlook is not up to date, please import the ics file again after upgrading.

After importing, please check if the event time shows correct in the Outlook web app.

Thanks,

Lance