Report not reflecting Event Time Zone

Hello,

I am running into an issue with all of my reports, and I don't believe I had this issue in the past.

When I run any filtered report on meetings, the report result will automatically adjust all of the events to my timezone, regardless of where the meetings occoured. This gives me results like lunch meetings at 5 PM, etc and a lot of other data that simply doesn't make sense.

I need to be able to run reports based on the data that was entered into the system, without that data being changed or manipulated.

If I am in Eastern Zone, and I run a report for someone in the Pacific Zone, and he lists a lunch as 11 AM PST, I need my report to show 11 AM, not show as 2 PM, which is what it is currently doing. You can see how this can be difficult?

Is it possible to do this, or is there a specific type of report that I can run that will NOT auto-adjust to my timezone?

Thanks

0 Chris Raffle 7 months ago

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

Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rodrigo Manara 7 months ago in reply to Chris Raffle
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;
Rodrigo Manara

Sr. Developer
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel