Forum Discussion

RachelMiller's avatar
RachelMiller
Qrew Cadet
2 years ago

Assistance with a trim formula

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
------------------------------
  • 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
    ------------------------------
    • RachelMiller's avatar
      RachelMiller
      Qrew Cadet

      Thanks Mark.  Both of these work however I forgot to mention that my logging field is set to put new entries at the top instead of the bottom.  This is because the field is logging dates and we want to see the most recent date at the top.  Can the formula be adjusted for that or do I need to change that setting?  I don't have a lot of data loaded yet so I can reload it if the setting has to be changed.



      ------------------------------
      Rachel Miller
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        Can you copy and paste (not a screen shot) what the data look like for a multiple entry logging?



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------