Date format in an email template

[lomixture]

Hi all

Is there a way of changing the date format on a custom field in an email template?

As you can see from the screengrab, we are using hcustom fields to pull data from a request, but our teams are complaining its in the American format and it is confusing things.

I've dug about but couldn't find a logical way of changing this, any ideas appreciated.

[Victor]

@lokent use "formatlocaltime" parameter on variable. Works only on date/time custom fields.

 

[lomixture]

Victor,

I tried to input this as the format {{h.custom_s}|formatlocaltime}} however it stopped any info being pulled through to the template.

Please could you clarify what format this should be input in?

[lomixture]

Ah, I need to remove the single } in the middle?

[Steve Giller]

11 minutes ago, lokent said:

Ah, I need to remove the single } in the middle?

Yes, and use a Date/Time field (h_custom_21 - h_custom_25)

[lomixture]

It didn't work! I tried three different iterations and every time it either left the email form with a blank or only pulled through the format not the actual info.

Would someone be able to tell me what the format should look like if this is what it currently reads? Currently it says:

My leaving date will be
{{.H_custom_s}}

I have tried the following:

{{.H_custom_s}|formatlocaltime}} (this pulls through nothing)
{{.H_custom_s|formatLocalTime}} (this just pulls through the blank code)

[lomixture]

Oh @Steve Giller- I think I've just realised what you're saying. I need to change the lettered custom field for a numbered custom field?

[Steve Giller]

@lokentSpecifically h_custom_21 - h_custom_25

h_custom_26 and higher are not Date/Time fields.

[Victor]

@lokent have a look at the documentation for mapping custom fields (link below). Any field that is if type DATETIME can be formatted for localtime and only this type of fields can be formatted with localtime.

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

[lomixture]

@Victor thank you, good for reference in the future.

Changing to the custom25 field worked a treat

[Guest Paul Alexander]

Just hijacking this thread for a bit!

Is there a way of converting the .fixby date field to a different date format in an email template?

I understand that I could add the .fixby information to a date/time custom field and then use that with the |formatLocalTime switch, but I don't want to have to do that to all of our Incident processes!