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 to remove time from a Date Concatenate Formula

Topic Labels: Dates & Timezones
441 1
Showing results for 
Search instead for 
Did you mean: 


I Created a Date field and used a formula field to output the day of the week because I’m hoping to get an output that reads something like, “Saturday, August 20, 2022” – When I use the concatenate function, the date formula changes from Friendly to ISO with time added. Time was not enabled on the date field.

Is there some other workaround to get what I’m looking for? Thanks in advance!
Screen Shot 2022-08-15 at 6.48.55 PM

1 Reply 1

Welcome to the Airtable community!

You need to use the DATETIME_FORMAT() function. It is documented in the Formula field reference. You will also want to see the Format Specifiers to get the parts you want.

DATETIME_FORMAT({Preferred Comp Day #1}, "dddd, MMMM D, YYYY")