cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate V
Advocate V

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
Highlighted
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

Highlighted
Advocate V
Advocate V

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
Highlighted
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.
Highlighted
Advocate V
Advocate V

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

Highlighted
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

Highlighted
Advocate V
Advocate V

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

Highlighted
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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (9,885)