Format Date In Formula

[dodom2]

Hello. How can I format the date in a formula? I've set the preferences already in system settings however its still formatting incorrectly. For example its doing 2020-06-13 whereis I need 06/16/2020.

Thanks!

[dodom2]

I figured it out guys! Below is what I came up with. I used the concatenate feature with the format formula found at this url (https://github.com/espocrm/documenta...datetimeformat)

name=string\concatenate(apparatusName,' Fuel For ',datetime\format(fillDate, 'America/Chicago', 'MM/DD/YYYY'));

[esforim]

Just a note, you don't need that America/Chicago there (or need that to be update to your Timezone), else you might get the wrong timezone.

EspoCRM save date and time with the timezone of +0 I believe, then each region/location get a - or + to that time.