How do I apply DATETIME_FORMAT in the same cell a date is calculated?

[Graig_Stettner]

I can’t seem to both calculate and format a date in the same cell. I add 55 years to a date of birth to come up with a 55th birthday (call this cell 55bday). That returns an ISO date that includes a time. I can, in another cell, use DATETIME_FORMAT and reference cell 55bday to remove the time. Can I do that all in one cell?

[Justin_Barrett]

No need to use DATETIME_FORMAT() at all. Change the formatting of the field itself to remove the displayed time. In the field configuration popup, click the “Formatting” tab.