Sam P Posted June 30, 2022 Share Posted June 30, 2022 My system.defaultWorkingTime.timezone setting is GMT Standard time but as the UK is currently in BST the answers to progressive captures and Human Task outcomes are being recorded one hour behind. In most cases, the date/time fields are written to Custom Fields either in the IC itself or in the BP - this is because I need to insert the answer to more than one question in a report. Can anyone help me to understand how I can have the report dates to be the exact date / time of the event as we know it, and whether or not this needs to be something I adjust every spring/autumn? e.g. Date Logged in real life today = 30/06/2022 at 10:00:00 is showing in the report as 2022-06-30 09:00:00 (also any advice on how to change the format of the date in the report would also help (Still quite new to reporting!)). Thanks Link to comment Share on other sites More sharing options...
Victor Posted June 30, 2022 Share Posted June 30, 2022 @Sam P you cannot change or, better said, format the date in a report. The reports are using whatever values are stored in the respective table in the database. Date/time values are always stored as GMT/UTC as this is used as a base of reference for formatting dates in the UI based on the user timezone and also used in email templates based on instance timezone. However there is no such formatting in reports (not yet anyway). You can theoretically have a formatted value in a report if you offset the date/time value (e.g. +1 hour) then store it in a custom field that you will specifically use for reporting (ideally will not be used for anything else as it is offset and will appear as "incorrect" in the UI and/or emails). Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now