PeterL Posted June 12, 2020 Posted June 12, 2020 Hello, We have had an issue arise where the schedule time is showing an hour behind and with a z at the end as per below: Once in the forms design view however it shows the correct time that has been chosen: Due to this some of the notifications sent out are displaying the time incorrectly and some even though it shows the wrong time is still outputting to the notification correctly: One that sent out correctly: Any help would be great thanks.
Alistair Young Posted June 12, 2020 Posted June 12, 2020 Hi all, just to add to this - it started today. Notification previews generated by tickets logged before today were working fine yesterday, but the same tickets are producing the same time format PeterL pasted above. 1
PeterL Posted June 12, 2020 Author Posted June 12, 2020 Having a look i can see the lates build has updated some time settings: The latest build of Hornbill ESP (3337) has been released to live.Added email template modifier called formatLocalTime to support formatting of dateTime columns/variables using system defined regional settings. This system modifier uses these system settings (system.regionalSettings.timezone and system.regionalSettings.dateTimeFormat) for formatting. Nothing above suggest why the time is an hour out but having a look more into this new modifier i can see: {{.datetimevariable|formatLocalTime}} = Allows formatting of datetime variables using system regional settings (system.RegionalSettings.timezone & system.RegionalSettings.dateTimeFormat), without this formatting the date time will use the DB value (UTC). So does this mean within my template where i am pulling the times: I will now need to do {{.H_custom_22|formatLocalTime}} ? Unsure how this would affect it displaying from within the ticket though?
Victor Posted June 12, 2020 Posted June 12, 2020 Yes, you need to format dates using the syntax you mentioned anywhere you use date values in email templates. Doers not impact how the date is displayed in UI, on requests, this is only valid for email template configuration.
PeterL Posted June 12, 2020 Author Posted June 12, 2020 @Victor Thanks, can you advise why it might be showing in the UI with the time being out by an hour with a z after it?
Victor Posted June 12, 2020 Posted June 12, 2020 29 minutes ago, PeterL said: why it might be showing in the UI with the time being out by an hour with a z after it @PeterL afaik, only is you store that date in a non-datetime field... for example if you store a date into Custom A field (which is a varchar type of filed) then it won't be formatted... where do you have it displayed like this?
PeterL Posted June 12, 2020 Author Posted June 12, 2020 @Victor Thanks for the response i am seeing the date format within the form view: As for the custom field we are using 22/23 which are identified as DATETIME, we have used it like this for some time now and not had an issue until after the recent build update Hornbill ESP (3337)
Victor Posted June 12, 2020 Posted June 12, 2020 @PeterL are those fields in request details section of a request?
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