Skip to main content
Question

Assistance with a trim formula

  • July 6, 2023
  • 0 replies
  • 218 views

I am using the following formula in a text formula field to trim out just the value (which is a date) of a log edits text field.  The formula is including the ------------ after the user name in the log field and I'd like to exclude them.  Is there a way to do this?

Trim(Right([my update field],"]"))

Log Edits Field Value

-- [JUL-03-23 Rachel Miller] --------------
06-30-2023

Formula Field Results

--------------
06-30-2023



------------------------------
Rachel Miller
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • July 6, 2023

    try this

    Trim(Right([my update field],10))

    That will take the 10 rightmost characters.

    But then I suggest changing your field type to be formula date

    ToDate(Trim(Right([my update field],10)))



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement