Date in formula to omit time stamp


#1

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?

00%20PM


#2
{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: