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

855 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Reply 1

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.