Report not reflecting Event Time Zone

Hi Tom Przybylak ,

Sugar stores all date/time values in the database as UTC time. It does not store an associated time zone with those records, and the behavior you are seeing is expected in that all date/time values are presented based on the current user's time zone setting. The only way you could extract information without it adjusting for your time zone is to write SQL queries via Sugar's Advanced Reports module. With SQL queries, you could apply the offset you want to the applicable date/time UTC values. Be cautious with this approach as you need to account for records on either side of daylight savings time and apply the offset accordingly (e.g. -7 or -8 hrs for Pacific time depending on the time of year the meeting was scheduled).

Chris

Just to your comment Chris Raffle  if need time conversion on the query , you can use MYSQL convert_TZ

SELECT
  CONVERT_TZ('2007-03-11 2:00:00','US/Eastern','US/Central') AS time1,
  CONVERT_TZ('2007-03-11 3:00:00','US/Eastern','US/Central') AS time2;

Just to your comment Chris Raffle  if need time conversion on the query , you can use MYSQL convert_TZ

SELECT
  CONVERT_TZ('2007-03-11 2:00:00','US/Eastern','US/Central') AS time1,
  CONVERT_TZ('2007-03-11 3:00:00','US/Eastern','US/Central') AS time2;