Skip to main content

Date in formula to omit time stamp

  • June 20, 2018
  • 1 reply
  • 182 views
B

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?

    This topic has been closed for replies.

    1 reply

    J
    Forum|alt.badge.img+18
    {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:

      Terms & ConditionsAccessibility statement