Date/Time Formatting in Email Variable

[will.good]

Hi,

We are using Custom Field 21 as a start date for one of our new starter processes. We would like to include this variable in an email template, but are unable to format this as just a date - I am currently trying {{.H_custom_21|dd/mm/yyyy}} but this doesn't appear to be working.

How can we get the date to display as just DD/MM/YYYY in the template?

[Steve Giller]

The available options are listed on the wiki page. You are basically limited to the value as-is, or as formatted by the system.RegionalSettings.timezone & system.RegionalSettings.dateTimeFormat settings.

[will.good]

@Steve Giller

our date time format is set as

 

however this still displays as 2023-06-30 10:00:00Z

also using {{.H_custom_21|formatLocalTime}} does not return any value and the variable is just displayed in the email

[Steve Giller]

This is working fine for me:
Test 1:

Test 2 (after changing system.RegionalSettings.dateTimeFormat):

How are you populating the Custom 21 field?

[will.good]

The Custom 21 Field is being populated directly from the Request Details box on a request at the moment, by the advisor manually by editing the box

[Steve Giller]

That'll be why, then.

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

[will.good]

4 minutes ago, Steve Giller said:

That'll be why, then.

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

We are using a date-time picker on the field in the request details