Problem with the function string\concatenate(STRING_1, STRING_2)

[peterberlin]

Hello,
we use string\concatenate(STRING_1, STRING_2) in a workflow.

A date-time field is used as the string.

The problem is that this function displays the time minus 2 hours.
Example:
It says in the date-time field 17.06.21 10:05
changes the function to 17.06.21 08:05

how to correct this problem?
peter

[shalmaxb]

Could be because of timezone. There are two places, where you have to configure correctly:

1. General configuration under Administrator: Don`t use UTC, but Europe/Berlin (I guess from yor username)
2. Under User configuration in the user menu you will have to use the same setting: Europe/Berlin

I tested this right now on the demo of espoCRM.

[peterberlin]

Thank you.
Since 2015, our configuration has been Europe/Berlin. This is probably not the cause of the problem for us.
Otherwise we have never had problems with the date/time.

[yuri]

Hi Peter,

The string date value in the formula context (as well as in any place under the hood) is UTC. You need to convert your dates using the datetime\format function https://docs.espocrm.com/administrat...datetimeformat. If you omit the timezone and format in a function call, the default (system) one will be used.

[peterberlin]

Hi Yuri,
thank you.