Date and time formatting on approval tasks

[Will Darley]

We have some approval tasks setup on a change request flow. The intelligent capture form asks the user to specify the implementation window for the change, these dates are then pulled through to the approval task when sent to the approver but it displays in a strange format:

 

I've been told this is due to how Hornbill formats date and time values using the standard UTC format but I can't seem to find a way to change this.

 

From what I can see our system settings are configured correctly but the dates on the approval task just won't display in the correct format:

 

Can anyone advise?

[Jim]

You can try the wiki formatting, emails default to the database time value I believe so you have to tell it to be regional, view Date Formatting here 

Wiki Markup - Hornbill

and here Email Templates (hornbill.com)

 

• {{.datetimefield|formatLocalTime}} = Allows formatting of datetime fields using system regional settings (system.RegionalSettings.timezone & system.RegionalSettings.dateTimeFormat), without this formatting the date time will use the DB value (UTC).

[Will Darley]

Cheers @Jim, I've managed to get the dates in the approval task to display correctly using the wiki markup guidance of wrapping the entire field in []

Only problem is that the task authorisation email template pulls through the whole approval task details  so I can't edit the individual date fields in the email template:

 

This is how the dates look in the email template that comes through to the user:

Seems to be that the system tasks and email templates both have their own seperate default time setting, and require different ways of formatting to get the date to display correctly

[Sam P]

I ended up using Custom Fields for formatting dates and times that were used on Cards and Authorisations, with the added decision of whether its UK BST or GMT.  I'm sure there's an easier way but it works for me..I do find the way dates and times are handled in different parts of the database difficult to understand but that probably means I need to spend more time trying to work it out