Date in formula to omit time stamp

[Blanche_M]

My first fixed field is a formula that just pulls the records from 2 other fields, the second of which is a date. But when the date populates into the formula field, it shows up differently with a timestamp that I don’t want. How can I get rid of the time stamp and make the date show up as the “Friendly” format—like it is in its source field—when it’s being pulled by the formula?

[Jeremy_Oglesby]

{Organization} &
" as of " &
DATETIME_FORMAT({As Of}, 'LL')

Here’s a list of supported formats that can be used with DATETIME_FORMAT if you want to try out other formatting options:

Airtable - Support

Supported format specifiers for DATETIME_FORMAT

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the form "DATETIME_FORMAT(Datetime, 'format s...