Schedules time showing a Z

[PeterL]

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]

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.

[PeterL]

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]

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]

@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]

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]

@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]

@PeterL are those fields in request details section of a request?

[PeterL]

@Victor Yes they are.

[Victor]

@PeterL let's take this over PM