Date and Time Format - String Concatenate Formula

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pablo
    Senior Member
    • Aug 2015
    • 177

    Date and Time Format - String Concatenate Formula

    Hi EspoCRM Team,

    For the tasks module, we are using the formula string\concatenate:

    HTML Code:
    name = string\concatenate(clientName,' ',dateStart);
    It works perfect.

    However, the date format is not in the format we setup. Currently it's YYYY/MM/DD, where it should be DD/MM/YYYY.

    Also, the time is not correct. Seems to be in another timezone although we set it up to our country. Can this be a server configuration?

    Is there any way to use string\concatenate formula showing the correct date and time format?

    Thanks a lot.
  • yuri
    Member
    • Mar 2014
    • 8528

    #2
    Hi Pablo,

    System format and UTC is used there. Use datetime\format function https://github.com/espocrm/documenta...datetimeformat
    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

    • Pablo
      Senior Member
      • Aug 2015
      • 177

      #3
      Worked PERFECT!

      Thanks a lot yuri

      Best regards.

      Comment

      Working...