{{.H_datelogged}} in Email Template

[Daniella R. Goral]

Good day to all, 

In creating an email template, we find that the {{.H_datelogged}} comes out at a different time than the timezone of the Customer. Is there a way to log the actual logged time based on Customer Timezone? 

 

Example: Request {{.H_pk_reference}} has been assigned to your team {{.H_fk_team_id}} on {{.H_datelogged}}

This returns: 

Quote

Request SR00001641 has been assigned to your team MD on 2021-03-30 10:53:39Z 

The Customer had really logged this at 6:53:39.

 

Thank you for your help, as always!

[Victor]

6 minutes ago, Daniella R. Goral said:

logged time based on Customer Timezone

@Daniella R. Goral not quite. The issue with dealing with multiple timezones is that 6:53 looks fine for the customer for example, but will look incorrect for someone else receiving the email who is in a different timezone. Even if that would be let's say ok for your analysts, the customer might forward the email within their own organisation who in turn might have users in multiple timezones and again that 6.53 won't look right anymore.

What we would advise is to use a so called "common denominator". You can format the date/time value in the email based on the instance timezone. Then in the email you can specify that the date/time is GMT or PST (or whatever the timezone configured in the instance). This will eliminate any confusion as of what the actual time is.

The date/time can be formatted as follows: 

{{.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).

https://wiki.hornbill.com/index.php?title=Email_Templates

[David Hall]

Hi @Daniella R. Goral

You should be able to use a formatter on the template to format to local time as follows {{.H_pk_reference|formatLocalTime}} .  Full details of email formatting can be found here https://wiki.hornbill.com/index.php?title=Email_Templates

Hope that helps,

Kind Regards,

Dave

[nasimg]

Use {{.H_datelogged|formatLocalTime}}

 

[Daniella R. Goral]

Thank you, that worked!