Unanswered

Time zone problem with list's Calendar View

(1) Share

Report

Posted on by Albert-Chen

Hi,

I'm having trouble displaying date/time columns in a list's calendar view. Full day events are displayed spanning 2 days:

Background info about my data and schema:

The data is coming into a Power Apps table from a SharePoint list as a text string (e.g. "10/28/2023 10:30:00 AM").
In my dataflow, the date strings get transformed into a Date/Time column (not a Date/Time/Zone column), (e.g. 10/28/2023, 10:30:00 AM)
In Power Apps, the date columns have the following setting:
- Time zone adjustment: Time zone independent
I created a Calendar View in Dynamics 365 for the table/list with the following settings:
- Time Zone Display Mode: Specific Time Zone
- Display Time Zone: (GMT) Coordinated Universal Time

Configuring the Calendar View time zone settings in Dynamics 365 allowed my events to display the correct date/time. Without them, the calendar still tried to display them with a Pacific Time offset. Even though the times are now correct, events that are 12:00 AM to 12:59 PM (all day events) don't appear correctly. They come up spanning 2 days.

After editing the times for one of the events, I realized the calendar view still treated the date as if it was in Pacific Time, even though the calendar is configured for UTC. Anyone know a solution to this?

Either the calendar view is buggy or I'm missing something. I'm thinking of doing the following:

Setting a Pacific Time zone in the data flow so all times are in Pacific Time, and just let calendar view display the way it wants to (local time).
But I don't think this will work because I've already had problems where events on Pacific Standard Time appear incorrect when Standard Time transitions to Daylight Time (events past that transition are off by 1 hour).
Alternatively change my time zone to Arizona so the system hopefully stops trying to be clever. This seems like a crazy solution.

Any help appreciated!

Albert

Categories:

General

All responses (3)

Answers (0)

MJWhite 338 on at

Like (1)

Report

Time zone problem with list's Calendar View

Hi there

I had a similar, if not identical, problem to you. I found that the my list of data and calendar display of data couldn't get aligned during British summertime, when the UK is one hour ahead of UTC. Call me fussy, but I want my site to work 12 months a year and not just 6 months of the year!

My solution was a bit extreme, but works (I think) and has some unexpected benefits:

- My date/time fields are all time zone independent

- The calendar is configured to be time zone independent in the list configuration in power pages management

- I've an additional field for country code (I needed the country anyway)

- I've an additional field for City or region, for big countries like yours with multiple time zones (I needed city or region anyway)

Thus, when I enter the data, I can see clearly the (fixed) date/time for the Country and City/Region I specify (see below):

Hope that helps.
NN-26072117-0 2 on at

Like (1)

Report

Time zone problem with list's Calendar View

I want to add more detail to my previous post regarding I am having the same issue. The list Timezone display options whether blank or set to UTC adjust the time displayed on my event. My times are all timezone independent or date only.

To that extent, the setting is working correctly. When I inspect the page I see that the data-call-start and data-cal-end adjust to my own timezone and I have no control over that.

The calendar control in the model-driven app does not have this issue.

My goal is to show a calendar with events on that day that looks the same to everyone all over the world. Any advice?

My 12:01 UTC event for July 4 is showing on July 3:

The data-cal-start and data-cal-end are July 3 5am = July 4 5am causing my event to land on the wrong day:

Here is evidence that the call end is 5am July 4:

Time Zone Display Mode = blank to default to my date's defined settings. They are timezone independent:
vcd_planet 2 on at

Like (1)

Report

Re: Time zone problem with list's Calendar View

I am having this exact same issue. When I inspect a calendar date cell I look at the generated data-cal-start and data-cal-end. These time stamps have my timezone's current UTC offset. I set the options to specific timezone, Coordinated Universal time. I tried having no value. I tried dateonly fields and dateonly/timezone independent columns for the startdate in the list configuration. How do I make the calendar straight UTC time?