Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

316 1
Showing results for 
Search instead for 
Did you mean: 

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.