Multiple Timezones in a grid
-
We have a meeting app that tracks meetings across timezones. The app shows 3 days worth of data. The original programmers created a time table that contained each time(in 30 min increments) with an offset for the day. So, there are 48 times with the offset of -1, followed by another 48 with an offset of 0, and another set with an offset of 1. This structure supposedly worked well when they had one timezone. But now there are several timezones in a grid. The times are displayed as the same UTC time across several timezones. So, in London, the time is the UTC, and in NY the time is shown on the same row as ET. The created a stored proc that creates a temp table and adds a column for each selected conference room. :wtf: All dates are stored in the tables as UTC. When we are retrieving the data, it is converted to the correct timezone. With that ridiculously long background, the client wants tooltips with the correct Date and time of each cell. Before the other timezones, they used the offset. But now we're stuck with figuring how to get the correct date in the tooltip across the entire grid. Times are fine, date gets hosed as soon as it passes the UTC midnight (offset). Then it increments a day when the offset increments, but the UTC time offset also increments the date :omg: I know the answer is probably simple, but I'm not seeing it (and neither is my colleague). Any help greatly appreciated.