cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jdriele
Level 8

Calendar event display issue

Hello,

 

I discover a bug in my application with US user. When they use the Calendar default screen, to see Monday event they have to select Tuesday...

 

How can I correct it without telling to my user to have their week starting by Monday ?

 

BR

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Calendar event display issue

@Jdriele 

Understood, but, if there is just a date, then it will be whatever date and 12:00 AM by default (in whatever timezone it is in).  If you display that date in a timezone that is 1 hour more, then it is 1 hour less to the date, and thus, the date becomes a day earlier at 11:00 PM.  You will see in the TimeZoneOffset function (in the example of converting) that in order to correct, you are adding the timezoneoffset which is returned in minutes.

 

The templates are Sample Apps to help people get started on their own.  I don't believe they are intended to be "official apps" that are supported.  But, this particular question on the timezoneoffset in the templates has come up a few times, so, it's definitely not unknown.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Jdriele
Level 8

Re: Calendar event display issue

You're right, it's working, I still don't understand why, I will read again... Here the final code :

Office365.GetEventsCalendarView(defaultCalendar,
Text(Value(DateAdd( startDate, TimeZoneOffset(  ), Minutes )),"[$-en-US]mm/dd/yyyy",Language()),
Text(Value(DateAdd( DateAdd(startDate,2,Days), TimeZoneOffset(  ), Minutes )),"[$-en-US]mm/dd/yyyy",Language())
).Values

 

BTW, when I have done my test today for india and usa eastern, we were all at the same day and the meeting also. Even without TimeZoneOffset it should work. That why it's strange for me, thx you for your contradiction ^^

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Calendar event display issue

@Jdriele 

You need to look at your date selections and usage in your formulas and make sure you are using the TimeZoneOffset function to adjust the dates properly. 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Jdriele
Level 8

Re: Calendar event display issue

Thx for you attention, but meetings are display in the wrong day. Not a prb of hours. Me and my colleagues are on Monday for the same meeting, just the hours should change.

 

BTW, why MS official template screen are not resilient for common regional issue

Super User
Super User

Re: Calendar event display issue

@Jdriele 

Understood, but, if there is just a date, then it will be whatever date and 12:00 AM by default (in whatever timezone it is in).  If you display that date in a timezone that is 1 hour more, then it is 1 hour less to the date, and thus, the date becomes a day earlier at 11:00 PM.  You will see in the TimeZoneOffset function (in the example of converting) that in order to correct, you are adding the timezoneoffset which is returned in minutes.

 

The templates are Sample Apps to help people get started on their own.  I don't believe they are intended to be "official apps" that are supported.  But, this particular question on the timezoneoffset in the templates has come up a few times, so, it's definitely not unknown.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Jdriele
Level 8

Re: Calendar event display issue

You're right, it's working, I still don't understand why, I will read again... Here the final code :

Office365.GetEventsCalendarView(defaultCalendar,
Text(Value(DateAdd( startDate, TimeZoneOffset(  ), Minutes )),"[$-en-US]mm/dd/yyyy",Language()),
Text(Value(DateAdd( DateAdd(startDate,2,Days), TimeZoneOffset(  ), Minutes )),"[$-en-US]mm/dd/yyyy",Language())
).Values

 

BTW, when I have done my test today for india and usa eastern, we were all at the same day and the meeting also. Even without TimeZoneOffset it should work. That why it's strange for me, thx you for your contradiction ^^

View solution in original post

Super User
Super User

Re: Calendar event display issue

@Jdriele 

One thing to watch out for...you will want to put your date in the TimeZoneOffset function.

If you use TimeZoneOffset without a date, it will calculate the offset based on the current time zone, not the time zone of the actual date you want.

 

So, your formulas should have TimeZoneOffset(startDate) in them.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,084)