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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • peterberlin
    Active Community Member
    • Mar 2015
    • 1004

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

    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
    Senior Member
    • Mar 2015
    • 1611

    #2
    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.

    Comment

    • peterberlin
      Active Community Member
      • Mar 2015
      • 1004

      #3
      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.

      Comment

      • yuri
        Member
        • Mar 2014
        • 8501

        #4
        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.
        If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

        Comment


        • peterberlin
          peterberlin commented
          Editing a comment
          Hi Yuri,
          thank you.
      Working...