I'm putting together a conference in Berlin (UTC -2 timezone) and my drupal install is in US Eastern (UTC +4). When I try to create any schedule timeslot that goes past 10 PM, it will not display on admin/conference/NID/schedule/DATE, but it is in the database. I have tracked it down to being an offset issue around line 77 of cod_support/cod_schedule/plugins/content_types/cod_schedule_scheduler_pane.inc

It appears that the timeslot data is being stored in the Berlin TZ, but the scheduler pane is trying to bring it out as UTC time. this is what I'm seeing:

Offset = -7200 seconds (-2 hours)
start/end as stored: 2017-10-05 20:00/23:00
day start variable: 2017-10-04 22:00
day end variable: 2017-10-05 22:00

When trying to execute the entity query, it limits it so that the start/end times are within the day. As this appears to end after the day ends, it's not included.

To make it work, I have set the offset to 0. The other option, especially if we have timeslots that span midnight, is to remove the day end from the query.

Comments

RobbMLewis created an issue.