Save Date field of Date-Time field?

[mudokai]

For calls, I'd like to create a formula that takes just the MM/DD/YYYY from Date Start and saves it without the HH:mm, is there a formula that could achieve this? Thanks

[shalmaxb]

You can use datetime\format for that, whre you can determine, which part is displayed for your purpose.

[mudokai]

It's just not doing anything when I use formula on before save...can you provide an example formula?

[victor]

mudokai,

cYourFieldName = datetime\format(dateStart, 'America/New_York', 'MM/DD/YYYY');

More about this formula: https://docs.espocrm.com/administrat...datetimeformat.

[rabii]

This won't work as it will throw an error

Invalid datetime format

Best way to copy date from a date-time to a date field is by constructing it using formula function date - month and year.