Appointment UTC TimeZone in Outlook when created by a plugin Under o365

(0) Share

Report

Posted on by sharchies

Hi everyone,

I have the following problem :

We worked on CRM online.
We developed a business process (c# plugins) which creates users' appointments in CRM.
These appointments are correctly created in CRM and appear correctly under Outlook.
The problem appears when the user open the appointment and try to change the start or end time

Time appears in UTC. That’s not an error but that doesn’t make any sense for the user and it’s really not comfortable for him if he has to update the start/end time.

Until now, I did not find any way to change that. Working around UTCConversionTimeZoneCode or TimeZoneRuleVersionNumber didn't work.

Any idea ?
Stéphane

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (1)

Community Member on at

Like (0)

Report

Try DNS_MSCRM.dbo.fn_UTCToTzCodeSpecificLocalTime

If my response is helps you, please mark as "Verified"

Was this reply helpful? Yes No
sharchies on at

Like (0)

Report

Hello,

Thanks for the answer.

Unfortunately, we are working with CRM Online and we don't have access to the SQL server functions.

Stéphane

PS: when working with an on-premise CRM/SQL server, you don't get this problem, you just have to set the Regional Settings of the server (if only 1 timezone used).

Was this reply helpful? Yes No
sharchies on at

Like (0)

Report

In fact, we have this problem of UTC TimeZone under Outlook for all appointments created via MS-CRM, even those created manually by a user.

I've checked both CRM and Office365 TimeZones for all users, they are correct.

Is it general for everybody (CRM online Office 365 +) ?

Is it possible to force the value of the TimeZone Under Ms-CRM ?

Was this reply helpful? Yes No
Rickard Norström on at

Like (0)

Report

Hi,

How do you create the appointments (what does the code look like) and, yes, you can force the value. (btw isn't Paris in UTC, or is that just during the winter?)

Was this reply helpful? Yes No
Aiden Kaskela 19,696 on at

Like (0)

Report

Hi Stephane,

Not a direct answer to your question, but you can convert time zones in a supported way in CRM Online by using a LocalTimeFromUtcTimeRequest request.

I wrote up a ton of details on how to get a date in the local user's timezone here - maybe it'll give you some ideas. community.dynamics.com/.../181386

Thanks,

Aiden

Was this reply helpful? Yes No
sharchies on at

Like (0)

Report

Hello Rickard,

Actually the problem also occurs when appointments are created manually by a user, so the code is out of the scope. I've checked both CRM and Office365 TimeZones for all users, they are correct.

The system is running on CRM Online, Office 365 and with a server sync (in, out mail & calendar).

How could you 'force' the timeZone value of an appointment ?

Stéphane

NB: Paris is in UTC+1 TimeZone and UTC +2 in the summer

Was this reply helpful? Yes No
sharchies on at

Like (0)

Report

Hello Aiden,

Working with timezone and CRM UTC data is sometimes ... not evident but I've learned how to manage them. In this case, time appears correctly in both CRM and Outlook calendar. So there are no 'error' stricto sensu.

The problem is for the user when he opens an appointment under Outlook and wants to change the time (see picture in my first post) : because of the UTC timezone setting, this is clearly not straightforward, he has to change the timezone and after that correct both start and end time or translate the real time in UTC time ...

Was this reply helpful? Yes No
Aiden Kaskela 19,696 on at

Like (0)

Report

It was more a response to the user who suggested manipulating the time zone via SQL.

Was this reply helpful? Yes No
Rickard Norström on at

Like (0)

Report

Hm, well, yes and no is perhaps the correct answer. When you create an appointment by code you can set the start and end time with a time zone However, as soon as the appointment hits the database that is translated to UTC, which is probably why outlook sees it as UTC. CRM is then translating that time in UTC into the time zone you're setting in you personal settings and displays it on the correct time according to your settings.

An appointment starting at 3pm in New York will be stored as 21 UTC (I think), well, maybe.... you still have daylight saving that will make things harder for you.

Was this reply helpful? Yes No
sharchies on at

Like (0)

Report

I'm agree but that does not make any sense to display the server timezone in an Outlook appointment.

I guess the problem lies in the CRM / Outlook synchronization module. I hoped to find a way to force this timezone value at this level.

Was this reply helpful? Yes No