Date Discrepancies

[Jeremy]

Please see below image, we choose the correct time in the PCF and when we email taking the date from the PCF it changes it to an hour earlier?

[Nikolaj]

Hi @Jeremy we have a similar problem. We thought it has something to do with different time zone

 

best regards

Nikolaj

[Jeremy]

We have tested a couple of times, we think that maybe this is to do with daylight savings....... Is there a setting that can be switched to allow the system to pick up what we have selected without adjustment.

[Jeremy]

@Hornbill Support Team anyone know why this is happening?

We are struggling at the moment with one of our departments which uses Service Manager to book appointments etc and these emails are confusing our customers.

[Steve Giller]

@Jeremy
Could be the way you have the ProCap set up, or the way the BPM is using the variable, possibly which custom field you store it in, of you are doing so, or the timezone settings of the customers and users, or the way you have the email template configured.

It's not really something we have enough detail to diagnose so far.

[Jeremy]

So from the ProCap:

We take the date and make it more useable:

And then inject this into a custom field to use in an email template and a timeline update the Questions show the ProCap as correct, but when using the Date Formatter it seems to account for something which we don't want. Do I need to change something in the Output Format to make it show the same as the ProCap?

[Alberto M]

Hi.

We reported this one month ago. For us, it has to deal with some users in different time zones that is causing the time in the "questions" section of the request to display a different time.

isn't this already being solved with the KE00165951 defect, @Steve Giller?

Regards,

Alberto

[Steve Giller]

@Alberto M The two may not be related - the KE you mention was specifically around the User's regional settings and ProCap/Questions - this involves date conversions and we have no details of User's Regional settings as yet.

[Steve Giller]

@Jeremy If I output the value of field_3 to the timeline I see 2021-03-01T13:13:13.000Z

This does not match the input Format you are presenting to the Date Formatter node.
I'd start with correcting that and testing again.

[Jeremy]

@Steve Giller what should be the correct input for this node?

[Jeremy]

Does anyone know what the correct date input for this node should be so that I can test to see if I can fix this issue?

[Steve Giller]

@Jeremy You would need to push your field_3 value to somewhere you can see it, e.g. the Timeline, and then ensure the input format matches the format of your field_3 value.

[Jeremy]

@Steve Giller this is the output:

2021-02-23T21:00:00.000Z

[Jeremy]

would anyone be able to help with the correct input for this date formatter node from the date:

2021-02-23T21:00:00.000Z

[Jeremy]

This is the raw outputted field and then the question from the form that has been filled in:

[Steve Giller]

7th April is after BST starts, so 07:00UTC is 08:00BST - that's displaying the correct time based on field_4's value.

[Jeremy]

@Steve Giller how do we get the time to be displayed the same regardless of BST?

As we are using this field to create appointments and send details in the emails and the date/time that we select is the correct one as far as we are concerned.

[Guest Yodit]

Hi @Jeremy I was dealing with a similar request for another customer and wanted to check that you had tried the below formatting options in the following areas: 

• Formatting date/time within an email
  You will be able to present the regional time by adding |formatLocalTime to the end of the variable in your email template.
  
  E.g. {{.datetimevariable|formatLocalTime}} 
  
  This will use the time zone selected in the two system settings below: 
  
  system.RegionalSettings.timezone
  system.RegionalSettings.dateTimeFormat
  
  More information can be found in the wiki here
   
• Formatting date/time within the details of an activity
  If you want to use a date/time variable in an activity, you will need to wrap the variable in square brackets
  
  e.g. [&[functions.pcf("askAQuestion","selectStartDate")]]
  
  More information can be found in the wiki here
   

The above settings will transform the dateTime stamp held in the DB (which is is UTC form) to your local time settings (in this case BST). If I have understood you initial post correctly, this should remove the need for the Date Formatter node in your BP. I would also recommend that the dateTime custom fields (h_custom_21 - h_custom_25) be used to map any dateTime values.

You mentioned that you are using this value to create appointments - just to double check, is this via an API integration (iBridge) or is this being done manually. I ask because the settings above will change how time is viewed in the UI and will not change the DB values themselves. 

On 3/2/2021 at 10:10 AM, Jeremy said:

As we are using this field to create appointments