What time zone are the timestamps on the site in?

For consistency, all CSV files (exports from activity log, task log, etc), will export timestamps in UTC.

In other words, no time zone offset is computed on timestamps in CSV data.

We do this deliberately, because data in any given CSV file may correspond to people located all over the world, and so the rows would be confusing if each was customised to the specific user in the row, but also the file may be exported by someone in one time zone and shared with someone in a different time zone.

So, by putting everything into UTC, data will always be consistent.

The logs in the UI will show timestamps according to the current user’s Time Zone (as per their own Profile & Preferences setting) so that the page they are viewing can be customised to them.

However, when CSV data is exported, everything is in UTC.

To summarise:

• CSV exports are in UTC, and customers will need to adjust timestamps to their local time zone as needed.

• Logs and timestamps in the UI are shown based on the user's time zone settings.

What if I need my Excel report to show data in a specific time zone?

We suggest that you apply a time zone offset within Excel according to what time zone you need.