Jump to content

Tasks using GMT dates


Recommended Posts

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:

image.png.073be79f7c290727f4443cc25a3f1f75.png

Task:

image.png.f17e81ce5d59cad8cc26e26cf2a2c38a.png

Details:

image.png.057e71f44e658ef0b6026f72ad7f6ac7.png

Link to comment
Share on other sites

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. 

 

image.png

 

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

  • 1 month later...
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.

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...