
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 20, 2018 12:22 PM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 20, 2018 12:27 PM
{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...
