Tasks using GMT dates

[Caroline]

Hi, I have a date / time captured in Progress Capture Questions which I then use to populate Details and Tasks via the Business Process. Unfortunately this is then coming through as GMT not BST, which is causing confusion for the authoriser. It shows correctly in Questions but not in Tasks or when I append to Details. How can I get it to use the current time zone and not zulu?

 

Question:

Task:

Details:

[Guest Yodit]

Hi @Caroline , you will need to wrap the time variable within the task with [ ] - see example below. This will populate the local time (i.e. BST) as opposed to the raw UTC time. 

 

 

More info can be found in the "Date Formatting" section of this wiki markup page here : https://wiki.hornbill.com/index.php?title=Wiki_Markup

Let me know how this goes

Yodit

[Caroline]

Hi @Yodit Thanks for that solution, it works well within Hornbill, and the authorisation task is now correct, but the authorisation email still has zulu time which is still causing confusion. How do we get the correct date in the email?

[Victor]

On 8/5/2021 at 9:11 AM, Caroline said:

I have a date / time captured in Progress Capture Questions

When you capture this in PCF, do you map the answer to a specific field? (e.g. map the answer to a custom field in requests)

If Yes then you can have this formatted in app and emails if No then you need to, either directly in PCF or later in the workflow. Otherwise you cannot format the value to a specific time zone.

 

[Caroline]

Hi @Victor

Currently we are taking the PCF answer and putting it directly into the Auto Authorisation details as we didn't have a need to store it elsewhere. I will have a look at mapping it. Thank you for the suggestion.

[Victor]

3 minutes ago, Caroline said:

Currently we are taking the PCF answer and putting it directly into the Auto Authorisation details

The issue for emails, when done this way, is that as far as the email is concerned that date/time is just a string so HB will have no idea that it needs to be formatted nor will know how to format it. So it needs to come for a specific date/time field. So I would suggest mapping or storing this value in a dedicated date/time custom field. Then you can output this field in an email template. The field can then be formatted to the system timezone.

General info about PCF

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

List of available custom fields and their type

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

General info about email templates including formatting for custom fields

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