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?
Page 1 / 1
{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:
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.