time zones
4 TopicsTime zone erratically assigned
I'm using Bookings through an Education account at an R1 university. I have attempted setting up my calendar availability many different ways in Bookings, but I continue to experience the same error about which many others have complained. Unfortunately, the workaround that seems to work for business users is not an option in educational accounts. The option to "Always show time slots in business time zone" appears nowhere. This morning, I had a student book an appointment with me, thinking it was at 10a (PST), when it was actually a slot for 1pm (EST, and where we are located). The confirmation email I received showed the time as 12p (CST). This seems to be a perennial problem with Bookings, yet no one seems to have a solution for it in this particular context. We're not technically a "business," but major universities are BIG money for Microsoft. I can only imagine how much profit they are making selling their platform to a university like this, with >32k students and >12,000 employees, across all campuses. It seems like y'all might consider re-working the application code to develop a more stable solution. I never had this issue when our University still allowed us to use Google calendar with students. If someone has an answer, I will be forever in your debt.93Views0likes0CommentsNo Option for Changing Time Zone for Analytics & Reports
I have just got off the phone with support and they have told me at this time there is no option for changing the time zone for the analytics and reports inside the admin center for teams. This makes it a bit confusing when trying to track down a certain call. Hopefully this option can be added soon. Side note: Not to be confused for changing the time zone on your personal account settings, which seems to have no affect on the time zone listed for reports.3.8KViews0likes2CommentsBookings Make Time Zones Available
We have employees across multiple time zones. As a result, if the employee on the East Coast marks they will be unavailable the entire day (toggle All Day switch), then the employees in Central Time see the appointment as 1 AM current day - 12:59AM the next day ex. East Coast employee enters info for all day on 9/16 (12:00 AM - 11:59 AM), Central Time employee will see in the calendar 9/16 (1:00 AM) - 9/17 (12:59AM). This now makes it appear at first glance, the employee is unavailable for 2 days. Please have an option to turn on time zones for appointments for the companies that span multiple time zones.415Views4likes0CommentsForce world wide queries to single time zone
Hello, I hope somebody would be able to help me. We are using an Azure SQL database. When querying datetime fields, the result is adjusted for the time zone that you are in. As example, I have a column called CreationDate in table Bronze. A record is inserted in California with a system datetime of 1 July 08h00 (Pacific time). When somebody in Ireland queries the data, the value in CreationDate reflects 1 July 15h00 (Irish time). We know that we can force the time during query time (see query below), but that means that all reports need to include this logic. We would prefer if there was an Azure SQL configuration setting that will always return the same value, regardless of time zone. Could anybody tell me how we do this? Thank you - Jaunine SELECT [CreationDate] ,CONVERT(DATETIME2(0), [CreationDate], 126) AT TIME ZONE 'GMT Standard Time' AT TIME ZONE 'Pacific Standard Time' as pst_date FROM Bronze where trim([item]) = '1524200'Solved2.3KViews0likes5Comments