Jump to content

Data Exports Have Incorrect Timestamps


alexjvaughan

Recommended Posts

A view of incidents in Service Manager correctly displays the times that tickets were raised, however when an export is taken of that view the time stamps are 1hr out. We believe it's a time zone issue, as this report was done when clocks went back, but the issue is that Hornbill is inconsistent with its time management, i.e. ticket logged time as viewed via Hornbill interface is different to the the ticket time that Hornbill exports to files. While it's ok now (because we have changed to GMT), the issue will happen again when we switch back to BST.
 

Link to comment
Share on other sites

@alexjvaughan

All times are stored in the system as UTC (or Zulu - Zero Meridian) which as you point out happens to be the same as GMT when not adjusted for British Summer Time.

When displayed through the front end they are translated to the local time zone based on the user profile.

When you export it will be exported natively in UTC.

Cheers

Martyn

  • Like 1
  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...