Date in formula to omit time stamp
0
3522
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?
{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:
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...
