Jump to content

Time is 1 hour out when exporting View to Excel


Ann-MarieHolloway
 Share

Recommended Posts

The 1 hour difference will be due to BST.  The database will be storing the date in UTC.  After October 25th when the clocks go back to GMT, you won't see that hour's difference.

I will look to see if this should be exporting the dates as they are viewed in the request list rather than what is stored in the database.  You may also find that there might be some date options in Excel to specify your location which will format it for you. 

Regards,

James

  • Like 3
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
 Share

×
×
  • Create New...