Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Date in formula to omit time stamp

4493 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Blanche_M
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Reply 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:

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...